Sql Tuning

From: Navtej B <navtej_b_at_yahoo.com>
Date: Fri, 12 May 2000 09:32:30 -0700 (PDT)
Message-Id: <10495.105530@fatcity.com>

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. Received on Fri May 12 2000 - 11:32:30 CDT