Re: Analyze table function

ganesh_at_gtfs-gulf.com (Ganesh Raja) wrote in message news:<a8aed4.0112142145.50831be4_at_posting.google.com>...
> damian.gonsalves_at_skye.co.za (Damian Gonsalves) wrote in message news:<42adb2bb.0112140650.686bb31f_at_posting.google.com>...
> > Hi there
> >
> > Can anyone tell me if there is a way to determine if a table needs to
> > be re-analyzed. For instance to check if a spatial index is fragmented
> > or out of balance you can run the SDO_TUNE.ANALYZE_RTREE function
> > which will recommend whether to rebuild the index or not.
> >
> > So is there a way to determine if a table needs to be re-analyzed by
> > looking at the stats or something like that. I already know how to
> > check if a table has been analyzed.
> >
> > Any feedback will be greatly appreciated.
> > Damian Gonsalves
>
> Hi,
>
> Monitor the table that will tell you when u need to Analyze the table.
>
> For more info u can try the documentation Libary.
>
> HTH
>
> Regards,
> Ganesh R

Hi Ganesh

What is the name of this table that you can monitor to let you know when to re-analyze the table?

Thanks
Damian Received on Mon Dec 17 2001 - 01:43:20 CST