Home » SQL & PL/SQL » SQL & PL/SQL » rebuilding indexes / dbms_stats.gather_schema_stats (merged 5) 10.1.0.5 unix
icon5.gif  rebuilding indexes / dbms_stats.gather_schema_stats (merged 5) 10.1.0.5 unix [message #411542] Sun, 05 July 2009 02:15 Go to next message
cherry
Messages: 56
Registered: December 2007
Member
hi dba's

i have a question. before that i'll explain my scenario.

i have a staging table where there is a lot of dml happening everyday.

100,000 inserts
100,000 updates
100 delete

by the end of the week, table would have

100,0000 rows
100,0000 updates
1000 deletes

the size of the table grows every day & on a weekend, we issue a delete on the table, deleting 90% of the data.

1/ now my question is, should we schedule rebuilding indexes on this table on a weekly basis?

2/ should we be running dbms_stats.gather_schema_stats OR analyze on this table everyday / week?

pls send in your expert thoughts.
thanks
Re: rebuilding indexes / dbms_stats.gather_schema_stats (merged 5) 10.1.0.5 unix [message #411550 is a reply to message #411542] Sun, 05 July 2009 03:08 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ No.
2/ Yes.

Regards
Michel
Previous Topic: Difference in DML operations on Table and Global temp table
Next Topic: How to check Plan table
Goto Forum:
  


Current Time: Sat Dec 03 08:26:02 CST 2016

Total time taken to generate the page: 0.07347 seconds