467,106 Members | 1,312 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,106 developers. It's quick & easy.

When should we Reorg

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
  • viewed: 1176
Share:
1 Reply
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.

Similar topics

27 posts views Thread by Raquel | last post: by
16 posts views Thread by andy.standley@ecngroup.co.nz | last post: by
3 posts views Thread by andy.standley@ecngroup.co.nz | last post: by
2 posts views Thread by EpsilonAurigae | last post: by
13 posts views Thread by Yuri | last post: by
9 posts views Thread by Mikael | last post: by
reply views Thread by bwmiller16@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.