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: 25050
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: 64151
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: Fri Dec 09 23:35:43 CST 2016

Total time taken to generate the page: 0.05435 seconds