Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query not using indexes
> 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