Re: Help - Simple SQL query doing full table scans

From: Keith Boulton <kboulton_at_ntlunspam-world.com>
Date: Thu, 10 Jan 2002 08:25:45 -0000
Message-ID: <vac%7.5676$1s6.1112053@news6-win.server.ntlworld.com>

> You're then using the incorrect syntax for the index hint.
>
> But the real point is that forcing the thing to use the index is not going
> to help you very much (because if it did, the optimizer would have chosen
to
> use it in the first place!).

When was the optimiser made so good!

Just because the query would return all rows doesn't mean that is what is going to be fetched.

It is quite common (in my experience) to run queries to populate a list of rows, one of which is to be selected. The users generally look at only the first few pages so it is very advantageous to use the index to do the sort. Received on Thu Jan 10 2002 - 02:25:45 CST