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: Why index is not used?

Re: Why index is not used?

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sat, 22 Mar 2003 20:09:16 GMT
Message-ID: <BAA202E9.DBBC%markbtownsend@attbi.com> 





in article 97a82547.0303221206.4f147730_at_posting.google.com, Dima at
dima_rogozin_at_yahoo.com wrote on 3/22/03 12:06 PM:



> If I execute a query "select * from my_table where status = 2" it does

> full table scan in both cases (no records WITH status=2 and a few

> records).




Have you collected histogram statistics on the indexes in question ?
Received on Sat Mar 22 2003 - 14:09:16 CST












Original text of this message













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