Replacement of NUT EQUAL to (<>) for optimization
Hi all, As we know that NOT EQUAL skip index. I have seen many people uses alternatives to avoid this i.e, decode etc.
Pls. suggest . how we can replace NOT EQAUL and can pick index . For ex
select name
from emp
where empid <> 20;
Pls. suggest . how we can replace NOT EQAUL and can pick index . For ex
select name
from emp
where empid <> 20;
0