Home » RDBMS Server » Performance Tuning » is there any need of rebuild pk index (oracle 9i (9.2),linux rhel3)
is there any need of rebuild pk index [message #408842] Thu, 18 June 2009 00:55 Go to next message
suryakantnirala
Messages: 19
Registered: May 2009
Location: Mumbai
Junior Member
after statistics gathering my database is slow down.
is it help to rebuild all indexes including primary key & unique key indexes.
Re: is there any need of rebuild pk index [message #408845 is a reply to message #408842] Thu, 18 June 2009 01:02 Go to previous messageGo to next message
BlackSwan
Messages: 25151
Registered: January 2009
Location: SoCal
Senior Member
Ready, Fire, Aim
Re: is there any need of rebuild pk index [message #408855 is a reply to message #408842] Thu, 18 June 2009 01:35 Go to previous message
Michel Cadot
Messages: 64294
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you read the sticky topic of this forum?

Regards
Michel
Previous Topic: ORA-1652: unable to extend temp
Next Topic: Database stops responding when run on production server
Goto Forum:
  


Current Time: Tue Jan 24 01:16:04 CST 2017

Total time taken to generate the page: 0.24320 seconds