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
sparsel
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
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 MA
ool off');
dbms_output.put_line('@c:\reb_index2.sql');
END;
/
spool off
[EMAIL PROTECTED]:\reb_index1.sql
--------------------------------
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de
Veeraraju_
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
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 tha
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 f
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..
Di
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
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
--
Pl
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
11 matches
Mail list logo
