Devart Forums

During filtering dataset Unidac is using function
TOCIMetaData.GetIndexColumns which is very slow on some Oracle Servers (query duration approx 3 seconds). This is unnecessary operation (query is selecting index columns for Locate after filtering which is not necessary (BDE was moving to first record in set in this situation).
Please modify this behaviour.

Hello,

To avoid searching key fields you should manually set the KeyField property, in this case the TOCIMetaData.GetIndexColumns method will not be called.
We will investigate the possibility of changing this behavior in one of the next versions.