Re: Oracle 9.0.1.0.0 and the indexes ...

From: logiclin <member31237_at_dbforums.com>
Date: Mon, 16 Jun 2003 16:01:36 +0000
Message-ID: <3007456.1055779296@dbforums.com>

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

Received on Mon Jun 16 2003 - 11:01:36 CDT