I have created my indexes my questions is can I use these indexes in my sql or qbe to make my queries faster? If so, could you kindly guide me through how to do it? Thanks

Yes, when you create indexes, QBE and SQL queries will be faster. This is automatic, you don't have to do anything. You don't want to randomly put a bunch of secondary indexes on your tables so the trick is to add the secondary indexes that will help. When a query is slower than expected, analyze the query to see what fields it is grouping and sorting on. For example, if a query is using State and City fields for grouping and/or sorting, you might consider adding a State>City and/or a City secondary index.

The exception to the "it's used automatically" is when coding. For example, if you use a TCursor to perform a task, you might get faster execution if you first switch to an appropriate secondary  index using ObjectPAL's switchIndex method.

Its so difcult to understand this table because of its fuctionality, currntly i‘m working at android app project that is given by android app development company, that‘s why i dont have time to understand this.

Prestwood board forum has been doing wonderful since its inception. Prestwood boards have been providing writing help for the help of understudies. Keep doing the same way to get something big.