Hi All,
I am having a sql statement with " *in clause*".
for example:
select emp_id from emp where ename in ('vikas','krishna','john','scott');
When I check the explain plan it doesn't use the index here even if the statistics has been populated. It always goes for full table scan.
There is an index created for column ename.
Please tell me a technique as to how to make use of the index here.
Thanks & Regards,
Vikas Krishna