RE: Checking the rebuildability of an index

If memory serves correct (and it might not) both Tom Kyte and Jonathan Lewis have stated that in most circumstances rebuilding indexes is useless. I think Tom may have said he could count the # of times he had to rebuild an index on one hand (something like that). Thus, I have stopped worrying about this one so much and will only entertain rebuilds if I start to see performance issues. Of course if you have the time and need to look busy keep rebuilding those indexes :)

By the way the reason it is useless is not that there is never a performance gain but that most indexes that need to be rebuild quickly degrade again and the period that one experiences a performance gain is minimal. Operating off a poor memory here so hopefully I have not misrepresented anyone.

Ethan Post
perotdba (AIM), epost1 (Yahoo)

-----Original Message-----
Sent: Tuesday, August 06, 2002 1:05 PM
To: Multiple recipients of list ORACLE-L

Actually, I do the 'validate structure' as well, and neglected to include it in my previous post.

Jared

> also send the HELP command for other information (like subscribing).
>

-- 
__________________________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

Get 4 DVDs for $.49 cents! plus shipping & processing. Click to join. 
http://adfarm.mediaplex.com/ad/ck/990-1736-3566-59

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajesh Dayal
  INET: rdayal73_at_techie.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  INET: Ethan.Post_at_ps.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).