ANALYZE INDEX...VALIDATE STRUCTURE....

I'm trying to analyze the fragmentation of an index, and I'm using the ANALYZE INDEX ... VALIDATE STRUCTURE command.

Unfortunately on a 4gig index this is proving to be very slow - and locks the table for insert/update/delete - not good as we are trickle feeding data into it.

Is there any other way that anyone can suggest/recommend for finding stats such as HEIGHT, DEL_LF_ROWS, PCT_USED, BTREE_SPACE etc., that is

1. faster

or

b) does not lock the table/index

thanks in advance,

Jon Waland
Vodafone Ltd. Received on Tue Feb 03 1998 - 00:00:00 CST