On 03/18/2004 03:37:24 PM, "Bobak, Mark" wrote:
> Something to keep in mind when contemplating a rebuild is that (unless you do LOTS of index fast full scans) performance will NOT be affected unless you can reduce the BLEVEL of the index.
> If you do a rebuild, and the BLEVEL doesn't change, you've probably wasted time and resources.
Well, not necessarily. If you can claim those hours as overtime and if the boss is satisfied by
the produced report, then rebuilding indexes ca actually further your career. That means that the
time and resources spent rebuilding indexes are not wasted.
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Mar 18 2004 - 15:56:52 CST
