When defining a index for a table, is there a way to define which index
to use in a search on the table (using CRecordset), or is this determined
internally by the database?
Thanks
Israel
Israel,
As always with SQL, this is determined internally. One of the purposes of SQL
is to shield you from explicitely specifying the access path. In most
production databases however, you can influence the optimiser. Usually either
by the order in which you specify the tables or by giving 'hints' about the
number or percentage of records you expect to qulify for a condition.
All of this is backend specific.
-Ronald-