Re: index fragmentation

Roman Starek wrote:
>
> Or another way of fragmentation.
>
> select * from user_segments where segment_name = 'your index';
>
> see column extents
>
> Starous

but of course you were also going to quote that number of extents typically will have absolutely no impact on performance...

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse