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: Andrew Allen <andrew.allen_at_handleman.com>
Date: 12 Sep 2002 13:06:30 -0700
Message-ID: <6dae400e.0209121206.4abbe108@posting.google.com> 






"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:<alq3jr$j9i$1_at_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.



Yeah, that's what I meant.  Little brain bubble got between my
thoughts and my fingers.
Received on Thu Sep 12 2002 - 15:06:30 CDT












Original text of this message













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