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.

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
Senior Member
Ready, Fire, Aim

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Did you read the sticky topic of this forum?

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 16:40:36 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.