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.
Re: Index rebuild [message #348504 is a reply to message #348502] Wed, 17 September 2008 00:55 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Rebuild is NOT a creation it is... a rebuilt.
See last_ddl_time column.

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


Current Time: Sun Dec 04 15:00:13 CST 2016

Total time taken to generate the page: 0.17602 seconds