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

Home -> Community -> Usenet -> c.d.o.server -> Re: simple query not using index

Re: simple query not using index

From: MMayer3077 <mmayer3077_at_aol.com>
Date: 2000/04/16
Message-ID: <20000416013351.10954.00000522@ng-cs1.aol.com>#1/1

  

The datatype is NUMBER(38) on the indexed column? This is a very large range of numbers. This index may not be working because this range of number values is so much larger then the number of records. Received on Sun Apr 16 2000 - 00:00:00 CDT

Original text of this message

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