Need to Check Large objects and Index Quality/Reorg
387378Jun 24 2009 — edited Jun 25 2009Hello,
I need to reorganize some large objects, how can we check what all are the large objects in database? so we can do reorganization of large objects.
Second thing is that some of index's are too big that also need to be reorganization, so i have to carry out index reorg also.
I have some doubts,
1) what is index quality and how can we check the existing index quality? what should be good index quality?
2) What is index rebuild/Index rebuild online and index compression, which one is the better for index reorganization?
Response will be highly appricitable.
Regards,
V.Singh