Re: Analyze table function

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 14 Dec 2001 21:45:06 -0800
Message-ID: <a8aed4.0112142145.50831be4@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 Received on Fri Dec 14 2001 - 23:45:06 CST