Re: Oracle 9.0.1.0.0 and the indexes ...

From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Tue, 17 Jun 2003 03:55:23 GMT
Message-ID: <LiwHa.4995$hz1.7539@sccrnsc01>

ANALYZE index yyy validate structure;
does not analyze an index. Do as Brian suggests and use dbms_stats.

Also a full table scan is not always slower than using an index. It depends.

Jim

-- 
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"logiclin" <member31237_at_dbforums.com> wrote in message
news:3007456.1055779296_at_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 - 22:55:23 CDT