Analyze table function

From: Damian Gonsalves <damian.gonsalves_at_skye.co.za>
Date: 14 Dec 2001 06:50:16 -0800
Message-ID: <42adb2bb.0112140650.686bb31f@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 Received on Fri Dec 14 2001 - 08:50:16 CST