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: which should be faster

Re: which should be faster

From: AK <oramagic_at_hotmail.com>
Date: Fri, 02 May 2003 13:31:39 -0800
Message-ID: <F001.0058E7B9.20030502133139@fatcity.com>


Actually I found a note on tom kyte's book(expert one on one) that it shouldn't matter weather u index c1,c2 or c2,c1 . Although my scenerio is not exact . But its kinda similer . I did a little testing and found that just invdate is faster compare to org , indate .

Thanks ,
-ak

> AK
> I would vote for just invdate. The index structure will be
smaller,
> a little faster to search. And if you have any queries that omit
> organization, the the optimizer may feel it can't use the index. But if
this
> is a critical decision, why not test it both ways. I've noticed that is
how
> the experts on this list are different from mediocre people like me --
they
> test a lot.
>
>
>
> Dennis Williams
> DBA, 60%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Friday, May 02, 2003 3:27 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I have table invoice with columns ( organization , invdate , amount )
>
> there are tons of query which do search on organization and invdate. But
> there is only one distinct value for organization .
>
> which index should be faster
> a. just on indate or
> b. ( organization, indate ).
>
>
> -ak
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  INET: oramagic_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Fri May 02 2003 - 16:31:39 CDT

Original text of this message

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