Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Forcing use of an index

Re: Forcing use of an index

From: GreyBeard <Fuzzy.GreyBeard_at_gmail.com>
Date: Thu, 17 Mar 2005 13:27:40 GMT
Message-Id: <pan.2005.03.17.14.28.52.135483@gmail.com>


On Thu, 17 Mar 2005 05:19:31 -0800, Bob P wrote:

>
> Any idea's how I can force the index to be scaned instead of the table?
> Or any better ways to do this query? If it helps the load_id column
> can be alphanumeric but my input will always be numeric only.

WHat proof do you have that using indexes will be a benefit? Received on Thu Mar 17 2005 - 07:27:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US