Home » RDBMS Server » Server Administration » Reorganize table and index (Oracle 9.2.0.6.0,Sunos)
Reorganize table and index [message #542450] Tue, 07 February 2012 06:10 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi,

We deleted millions of records from a table.

1.Is it necessary to reorganize a table and index after the deletion of records
from table ? Because i see some change in table size after table and index reorganization.
2.Will re org table and index improve the database performance ?

Can somebody clear my doubts?

Regards,


Re: Reorganize table and index [message #542457 is a reply to message #542450] Tue, 07 February 2012 06:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
millions out of how many?

Regards
Michel
Re: Reorganize table and index [message #542465 is a reply to message #542457] Tue, 07 February 2012 06:59 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

No idea.

Actually it was deleted by application team .

Re: Reorganize table and index [message #542493 is a reply to message #542465] Tue, 07 February 2012 08:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't know how many rows there are in your table?

Regards
Michel
Re: Reorganize table and index [message #543835 is a reply to message #542493] Fri, 17 February 2012 03:12 Go to previous messageGo to next message
anil_mk
Messages: 146
Registered: August 2006
Location: Bangalore, India
Senior Member

Yes Balaji if more DML on table then you can re-org the table.

Thanks,
Anil MK
Re: Reorganize table and index [message #543839 is a reply to message #543835] Fri, 17 February 2012 03:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Prove your claims!
Anyone can post anything even wrong or injuring stuff.
Few can prove that what they post is correct.

Regards
Michel
Re: Reorganize table and index [message #543990 is a reply to message #543839] Sun, 19 February 2012 00:48 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

No,actually what Anil said was correct.I had an experienced on reorganizing tables and then
rebuilding their indexes.But the purpose i raised the question is

1.i want to know more about in detail like how tablespace gains space in tablesapce.
2.What internally happens when we reorganize tables and indexes etc..

Thank you

[Updated on: Sun, 19 February 2012 00:49]

Report message to a moderator

Re: Reorganize table and index [message #543995 is a reply to message #543990] Sun, 19 February 2012 01:33 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What about reading the documentation?
You still did not do it after more than 5 years?

Regards
Michel
Previous Topic: move datafile to another tablespace
Next Topic: Reorg the tables and Indexes
Goto Forum:
  


Current Time: Thu Mar 28 06:45:21 CDT 2024