Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Tuning

Re: SQL Tuning

From: Pat <pat_at_microsoft.com>
Date: Fri, 29 Jul 2005 20:30:43 +0800
Message-ID: <dcd997$1k89$1@news.hgc.com.hk>


thx.

"Ed Prochak" <ed.prochak_at_magicinterface.com> wrote in message news:1122576123.602003.322060_at_g14g2000cwa.googlegroups.com...
> Tuning isn't for beginners. Might I suggest you start with Tom Kyte's
> SQL book? (Or contact me and I can get some one there to help you)
>
> One bit of general tuning advice: KNOW THY DATA
>
> A query tuned for one set of data may run deathly slow on another set
> of data. So be sure you get hardware and data equal to the production
> environment.
>
> HTH
> ed
> (my work account is down temporarily [dam spammers]
> so send to: edprochak
> at alltel dot net )
>
Received on Fri Jul 29 2005 - 07:30:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US