By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,651 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

When should we Reorg

P: 14
HI
Plz tell me

when u will suggest to reorg the database? Lets suppose you are deleting or inserting nearly 100 of records in a day, will you be suggested to reorg at weekly basis. Give the reason?

Thanks
Aug 16 '07 #1
Share this Question
Share on Google+
1 Reply


P: 1
Reorg organises your table data according to the indexes present on it. I would advise you to reorg only those tables which are huge and are accessed more frequently e.g for stuff like generating reports. If its just 100 per day like in the case below, do fire a Reorg twice in a month.

HI
Plz tell me

when u will suggest to reorg the database? Lets suppose you are deleting or inserting nearly 100 of records in a day, will you be suggested to reorg at weekly basis. Give the reason?

Thanks
Aug 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.