Re: Oracle Tunning (DRPP)

Joe Testa wrote:
>
> Tuning will never totally go away since some duveleopers will still code
> like this(as well as them dumb gui tools):
>
> select a.deptid, b.last_name
> from dept a, emp b
> where a.dept_id = '22;
>
> Oh look a cartesian join, how lovely.
>
> Duhveloper: DBA why does my query take so long?
> DBA: let's talk about tuning.
>
> joe

100% with you. Made a 19mn query run in less than 4s last week simply by rewriting it. Didn't even touch indices. This is to say about much I bothered about obscure init.ora parameters.

-- 
Regards,

Stephane Faroult
Oriole Ltd
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

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).