Home » RDBMS Server » Performance Tuning » Index rebuild (AIX 9.2.0.6)
Index rebuild [message #348502] Wed, 17 September 2008 00:50 Go to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member
Hi,

I have rebuild 10 indexes at my test database.

sql> ALTER INDEX <INDEX_NAME> REBUILD ONLINE;


But I cannot able to see the information when those indexes created.

I have checked the "CREATED" column at dba_objects but it showing the old creation date of those indexes.

Please help.

Pokhraj.

Report message to a moderator

Re: Index rebuild [message #348504 is a reply to message #348502] Wed, 17 September 2008 00:55 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Rebuild is NOT a creation it is... a rebuilt.
See last_ddl_time column.

Regards
Michel

Report message to a moderator

Previous Topic: Low oracle performance
Next Topic: Run time versus Elapsed time
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 09:31:37 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.