Re: force use of an index - how to?

From: Scott Urman <surman_at_oracle.com>
Date: 1995/04/19
Message-ID: <3n24f1$isl_at_dcsun4.us.oracle.com>#1/1


In article <D76z5y.CAp_at_corsair.daytonoh.attgis.com>, Jim Gregory <Jim.Gregory_at_daytonoh.attgis.com> writes:
|>

deleted...

|> ++
|> Instead of the order by clause try using where lastname > "" and middlename >
|> ""
|> and firstname > ""
|>
|> That should force use of the index to return in the correct order without
|> doing a sort.
|>
|> Jim Gregory

This may return the rows in order, but it's NOT guarenteed. The ONLY way to guarentee that the rows will ALWAYS be in order, regardless of database version, platform, number of indices, etc. is to use an order by clause. Received on Wed Apr 19 1995 - 00:00:00 CEST

Original text of this message