Re: index rebuild
- From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 18 Mar 2004 16:18:27 -0500
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
