Re: rebuilding indexes - sure to cause a ruckus

How about: Keep re-analyzing your tables and indexes. Run gather_statistics (or whatever) all the time.

Bobak, Mark wrote:

>I think this subject has been done to death. We should talk about less contentious issues such as:
>
> - The buffer cache hit ratio, your friend in expert Oracle tuning!
> - Rebuild your tables regularly to reduce the number of extents and improve performance!
> - Disk access is at least 10,000x slower than memory, to tune your database, eliminate physical I/O!
>
>Anyone else got and good ones? ;-)
>
>-Mark
>
>-----Original Message-----
>Sent: Wednesday, December 10, 2003 5:24 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>
>>BTW, does anyone know what a rocket scientist refers to when
>>they say "Hey,
>>this is all quite easy, it sure ain't ?????" ?
>>
>>Cheers ;)
>>
>>Richard
>>
>>
>
>Surely the Rocket Scientist version must be "Hey, this is all quite easy, it sure ain't index rebuilding"
>
><very evil grin>
>
>Ciao
>Fuzzy
>:-)
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: mln_at_miracleas.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).