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: Query not using indexes

Re: Query not using indexes

From: Dario <drga59_at_hotmail.com>
Date: 8 Jul 2004 21:12:00 -0700
Message-ID: <e409f463.0407082012.4963b052@posting.google.com>


> However, I'm only getting a single row back (out of 1 million).
>
> SELECT fieldA
> FROM tableA
> WHERE fieldB = 'xxx'
>
> And fieldB is indexed.
> Seems like a very simple query, with fresh statistis.
> That's why this is puzzling me so much....

What is cardinality of fieldB, is it skewed, does it have proper histogram? Received on Thu Jul 08 2004 - 23:12:00 CDT

Original text of this message

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