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 in query execution plan ?

Re: why index is not used in query execution plan ?

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Thu, 12 Sep 2002 17:07:54 +0400
Message-ID: <alq3jr$j9i$1@babylon.agtel.net> 






> Since you are using 8i, I would suggest that you change to

> DBMS_ANALYZE instead of analyze table. 




I think you meant DBMS_STATS here.


-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


Received on Thu Sep 12 2002 - 08:07:54 CDT












Original text of this message













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