Re: Fragmentation/Vacuum, Analyze, Re-Index

[DM <dm.aeqa@xxxxxxxxx>]

Is there any script/tool to identify if the table requires full vacuum? or to re-index an existing index table?

Thanks

Deepak

On Fri, Jan 22, 2010 at 12:11 AM, DM <dm.aeqa@xxxxxxxxx> wrote:

Hello All,

How to identify if a table requires full vacuum? How to identify when to do re-index on an existing index of a table?

Is there any tool for the above?

Thanks

Deepak Murthy