Mahir M. Quluzade wrote:Dera Mahir
Did you try function based index ?
for example :Regards
create index emp_length_idx on emp(length(ename));
Mahir M. Quluzade
what is it that you want to do after finding such records? and since your table is huge full scan will take time.