Re: Q:Index fragmentation ?? interesting challenge ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 1 Mar 2012 09:42:58 -0000
Message-ID: <BC1031C7E24C4281B51555EB7015CC84_at_Primary>

It might be interesting to see what dbms_metadata says about the index definition - I'm wondering whether this is a system that has been upgraded from 9i.

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com
Oracle Core (Apress 2011)
http://www.apress.com/9781430239543

Original Message ----- From: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> To: <oracle-l_at_freelists.org> Sent: Thursday, March 01, 2012 9:27 AM Subject: Re: Q:Index fragmentation ?? interesting challenge ?

There's obviously a lot of empty space in the index - but it's not size that matters, it's what you do with it.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 01 2012 - 03:42:58 CST

This message: [ Message body ]
Next message: Sheldon Quinny: "Oracle Database 10.2 has now transitioned from Premier Support to Sustaining Support."
Previous message: Jonathan Lewis: "Re: Q:Index fragmentation ?? interesting challenge ?"
Maybe in reply to: Jonathan Lewis: "Re: Q:Index fragmentation ?? interesting challenge ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message