--- "Sergey M. Brytsko" wrote:
> The problem is the index is NOT used for query:
> SELECT BBB FROM XXX WHERE BBB <> 100;
>
> but in case of query
> SELECT BBB FROM XXX WHERE BBB > 100;
> all is ok
...
> The indices are very important for me, how should I build these queries?
Say you have the following values for BBB:
1 2 3 10 20 30 50 70 80 80 90 100 101 110 110 120 120 150 190 200
How is an index going to help you with BBB <> 100 ?
You have to do a full table scan whether or not the column is indexed.
____________________________________________________________________________________
Be a better Globetrotter. Get better travel answers from someone who knows.
Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545469
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
