Re: Oracle 9.0.1.0.0 and the indexes ...

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"