Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 9.0.1.0.0 and the indexes ...

Re: Oracle 9.0.1.0.0 and the indexes ...

From: Brian Peasland <oracle_dba_at_remove_spam.peasland.com>
Date: Mon, 16 Jun 2003 17:29:32 GMT
Message-ID: <3EEDFE7C.72356FF9@remove_spam.peasland.com>


Instead of the ANALYZE command, use the DBMS_STATS package.

HTH,
Brian

logiclin wrote:
>
> Yes, but after ANALYZE the query was more slower and there are no index
> using after that.
>
> We used this statements :
>
> ANALYZE TABLE xxx COMPUTE STATISTICS FOR ALL COLUMNS;
> ANALYZE index yyy validate structure;
>
> .. and we used Oracle manager tools to analyze tables and indexes, but
> no difference.
>
> So I don't know what I'm doing wrong, I don't understand why there are
> no index using on this ( and lot of other tables ).
>
> Joseph G.
>
> Originally posted by Jim Kennedy
> > Did you analyze the table and index?
> > Jim
>
> --
> Posted via http://dbforums.com

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Mon Jun 16 2003 - 12:29:32 CDT

Original text of this message

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