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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Sql Tuning

Re: Sql Tuning

From: Scott Shafer <scott.shafer_at_ildmail.com>
Date: Fri, 12 May 2000 17:26:20 -0500
Message-Id: <10495.105574@fatcity.com>


Doesn't the

/* +USE_CONCAT (tableAlias) */

hint improve the performance of OR's? At least if you have the resources?

--Scott

> good tip .. and in case you are rich on resources .. "keeping" indexes
might
> help too!!
>
> -----Original Message-----
> Sent: Friday, May 12, 2000 12:49 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Try replacing the OR with an AND like
> a.stat_code > 0 and a.stat_code < 3
> In general AND's perform better than OR's because an OR may cause multiple
> scans.
>
> > -----Original Message-----
> > From: Navtej B [SMTP:navtej_b_at_YAHOO.COM]
> > Sent: Friday, May 12, 2000 12:39 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Sql Tuning
> >
> > please tell me how to make it fast
> >
> > SELECT a.id,a.uid,
> > a.orderid,
> > a.invcid,
> > a.qid,
> > a.carrierid
> > from master_tbl a
> > where (((a.Start_dt<='10-MAR-00') and
> > ((a.Stat_code=1) or (a.Stat_code=2))) and
> > (a.edi_code=1))
> > order by a.Start_dt asc,
> > a.Party_name desc,
> > a.Query_dt asc
> >
> > Here cardinality for Stat_code is very low
> >
> > Can somebody provide guidelines for tuning
> >
> > Thanks
> > NavBir
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Send instant messages & get email alerts with Yahoo! Messenger.
> > http://im.yahoo.com/
> > --
> > Author: Navtej B
> > INET: navtej_b_at_yahoo.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).
> --
> Author: Elliott, Patrick
> INET: Patrick.Elliott_at_bestbuy.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).
> --
> Author: Thapliyal, Deepak
> INET: DThapliyal_at_ea.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
Received on Fri May 12 2000 - 17:26:20 CDT

Original text of this message

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