Re: How do we know that an index need to be rebuilt.

2003-09-22 Thread Prem Khanna J
Read ur interesting reply for the query Mladen and learnt a new rule of thumb from u today. i sent the doc. to Raju ONLY adn NOT to the list. it's just the body of the mail u r seeing there. Regards, Jp. 22-09-2003 15:49:40, Mladen Gogala [EMAIL PROTECTED] wrote: Attachments are stripped from

Re: How do we know that an index need to be rebuilt.

2003-09-22 Thread Mladen Gogala
There is a Metalink note 77574.1 entitled Guidelines on When to Rebuild a B- Tree Index which explains how to use validate structure and index_stats table. It is far too scientific to ever put into the script. Explanation for the rule of thumb is simple: if number of index blocks is big that

Re: How do we know that an index need to be rebuilt.

2003-09-22 Thread Prem Khanna J
Anand, it's the same doc. mentioned by Mladen. i have sent it to your email address ONLY. Jp. 22-09-2003 16:20:21, Anand Kumar [EMAIL PROTECTED] wrote: Prem, Can you mail me the same document -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J

RE: How do we know that an index need to be rebuilt.

2003-09-22 Thread Juan Miranda
set serveroutput on size 100 set pagesize 0 set feedback off set echo off set trimspool on spool c:\reb_index1.sql DECLARE dbname varchar2(20); wdayvarchar2(11); BEGIN

Re: How do we know that an index need to be rebuilt.

2003-09-22 Thread Prem Khanna J
That's the doc. i mailed raju. Thanx Mladen. can i add a question here : when is it appropriate to use BITMAP index ? seems it has lot of restrictions. read docs about it ...still confused. say, i have a big table with 50,000,000 records in a OLTP env. it has column SEX which will have either

RE: How do we know that an index need to be rebuilt.

2003-09-22 Thread Veeraraju_Mareddi
Thanks for all who responded. -- From: Prem Khanna J[SMTP:[EMAIL PROTECTED] Reply To: [EMAIL PROTECTED] Sent: Monday, September 22, 2003 1:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: How do we know that an index need to be rebuilt.

Re: How do we know that an index need to be rebuilt.

2003-09-22 Thread Tim Gorman
The problem that rebuilding indexes is attempting to resolve is sparseness. Lots of folks think that indexes become unbalanced over time and that is the reason for rebuild, but Oracle B*Tree indexes are always balanced. Sparseness is the symptom, however, not the cause. The problem with

How do we know that an index need to be rebuilt.

2003-09-21 Thread Veeraraju_Mareddi
Dear Friends, Can somebody tell me how do we that an index needs to be rebuilt.. Different scenarios / any documents will be helpful. Thanks in advance. Rajuvera ** This email (including any attachments) is intended for the

Re: How do we know that an index need to be rebuilt.

2003-09-21 Thread Prem Khanna J
Hi Raju, Check the doc. i have attached. HTH. Jp. 22-09-2003 14:59:35, Veeraraju_Mareddi [EMAIL PROTECTED] wrote: Dear Friends, Can somebody tell me how do we that an index needs to be rebuilt.. Different scenarios / any documents will be helpful. Thanks in advance. Rajuvera -- Please see

Re: How do we know that an index need to be rebuilt.

2003-09-21 Thread Mladen Gogala
Oracle indexes do not need rebuilding on the regular basis, but only as an exceptional event. The warning sign is when queries that utilize nested loops slow down without any apparent reason. The only case when index needs to be rebuilt is the case of a table with frequent delete operations. You

Re: How do we know that an index need to be rebuilt.

2003-09-21 Thread Mladen Gogala
Attachments are stripped from the list messages. On 2003.09.22 02:24, Prem Khanna J wrote: Hi Raju, Check the doc. i have attached. HTH. Jp. 22-09-2003 14:59:35, Veeraraju_Mareddi [EMAIL PROTECTED] wrote: Dear Friends, Can somebody tell me how do we that an index needs to be rebuilt..