Devart Forums

TOraTable.Locate Method no use the table index to search?

ODAC cannot use indexes that are created on the server for locating record on client. In any case, operation of locating record on client side needs all records to be present. You can increase performance if you choose another methods. Try to organize filtering on server side using FilterSQL property or including WHERE clause to the SQL statement.