Re: using index

yup this is true sql wont make use of index for <> case.......... but u can do one thing... modify your query for eg

select * from table_name
where sal <> 1000

conver it to

select * from table_name
where sal > 1000
or sal < 1000

u can not do this for all the cases but for few cases its possible

even if u force sql to use an index it wont give u better results rather performance will be worse
well try this to force
select * from table (index = INDEX_NAME) where --------------

Ng K C Paul wrote in message <6vjqth$7dg$1_at_imsp009a.netvigator.com>...
>Is is always true that in the where clause column with Not Equal(<>) will
>not use index?
Received on Fri Oct 09 1998 - 00:00:00 CDT