Home » RDBMS Server » Performance Tuning » DROP and CREATE INDEX and need for ANALYZE INDEX ... ESTIMATE STATISTICS
DROP and CREATE INDEX and need for ANALYZE INDEX ... ESTIMATE STATISTICS [message #183151] Wed, 19 July 2006 12:02 Go to next message
dmill01
Messages: 4
Registered: July 2006
Location: Miami, FL
Junior Member
In a large migration process one of my steps is to drop and rebuild indexes. Do I still need to ALSO do a ANALYZE INDEX to make sure the index is up to date with data and good to go with the best performance possible? Doesn't drop and recreating force it to be most recent and I would basically be doing same work twice?

This is Oracle 8i I am running on.

Just curious,
Miller

Report message to a moderator

Re: DROP and CREATE INDEX and need for ANALYZE INDEX ... ESTIMATE STATISTICS [message #183153 is a reply to message #183151] Wed, 19 July 2006 12:44 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Yes. You need to collect statistics on indexes again.
You must be using DBMS_STATS instead of analyze.

Report message to a moderator

Re: DROP and CREATE INDEX and need for ANALYZE INDEX ... ESTIMATE STATISTICS [message #183180 is a reply to message #183153] Wed, 19 July 2006 17:27 Go to previous message
jgarry
Messages: 3
Registered: July 2006
Location: Vista, CA
Junior Member
True in 8&9, not true in 10. See this. Oh wait, that is in response to this same question on OTN! Laughing

Report message to a moderator

Previous Topic: resize request completion
Next Topic: Performance Issue Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 13:10:18 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.