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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
