Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h45J1Am19049 for ; Mon, 5 May 2003 14:01:10 -0500 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h45J1AA19044 for ; Mon, 5 May 2003 14:01:10 -0500 Received: from fatcity.com (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id JAA74310; Mon, 5 May 2003 09:36:07 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0058FB2B; Mon, 05 May 2003 09:01:40 -0800 Message-ID: Date: Mon, 05 May 2003 09:01:40 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Subject: Re: Re: which should be faster Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit jonathan lewis posted over the weekend that it does. He said it does in 9i unless you have a certain parameter set. Cant remember what that was off-hand. > > From: "AK" > Date: 2003/05/05 Mon AM 11:46:41 EDT > To: Multiple recipients of list ORACLE-L > Subject: Re: which should be faster > > does predicate order makes diff in cob also ? > oracle 8.1.7 > > -ak > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" > Sent: Saturday, May 03, 2003 8:11 AM > > > > > > Did you also test with index compression in place > > on the organization column ? > > > > If your tests were: > > organization = 'XXX' > > and inv_date between .... > > > > did you also test > > inv_date between .... > > and organization = 'XXX' > > > > Under Oracle 8, the predicate order > > can make a difference - although in > > this case I don't think you would see > > much difference, as neither predicate > > is an eliminator at the filter level. > > > > > > Regards > > > > Jonathan Lewis > > http://www.jlcomp.demon.co.uk > > > > The educated person is not the person > > who can answer the questions, but the > > person who can question the answers -- T. Schick Jr > > > > > > One-day tutorials: > > http://www.jlcomp.demon.co.uk/tutorial.html > > > > ____Denmark__May 21-23rd > > ____Sweden___June > > ____Finland__September > > ____Norway___September > > > > Three-day seminar: > > see http://www.jlcomp.demon.co.uk/seminar.html > > ____UK_(Manchester)_May x 2 > > ____Estonia___June (provisional) > > ____Australia_June (provisional) > > ____USA_(CA, TX)_August > > > > The Co-operative Oracle Users' FAQ > > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" > > Sent: 02 May 2003 22:31 > > > > > > > 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 > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Jonathan Lewis > > INET: jonathan@jlcomp.demon.co.uk > > > > 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@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@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@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: