|
> When ReStore executes a query it use the DB indexes ?
When you query a database you don't need to have any knowledge of which
fields have indexes on them. The database will use an index if available,
and if not, will do a table scan(?)
So if you are using predicates on fields without indexes, and the table has
many rows, you'd probably benefit from placing an index on the field, but
this is done through the RDBMS management tool, not through any client tool
(Although I guess you could execute the required sql to create an index via
a client)
So in answer to your question: If an index has been defined, ReStore will
use it, just as a query via an access link table will use it
|