subject:"concatenated index"

RE: concatenated index

2003-07-09 Thread Niall Litchfield

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Richard Sent: 08 July 2003 06:09 To: Multiple recipients of list ORACLE-L Subject: Re: concatenated index I didn't mean that including RULE will prevent the index from being used - I

RE: concatenated index

2003-07-09 Thread Niall Litchfield

Thanks Stephane. Is there some place (some article) other than the Oracle Manual which deals with this(latest) features on the composite index Asktom has or had an article on this try (will likely wrap) http://asktom.oracle.com/pls/ask/f?p=4950:8:409221425463834426::NO::F495

RE: concatenated index

2003-07-09 Thread Jamadagni, Rajendra

Title: RE: concatenated index no_index is a valid hint ... it tells Oracle that exclude specified index from your consideration. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed

Re: concatenated index

2003-07-08 Thread Novice DBA

of list ORACLE-L [EMAIL PROTECTED] Subject: Re: concatenated index Date: Mon, 07 Jul 2003 21:39:25 -0800 MIME-Version: 1.0 Received: from ns3.fatcity.com ([66.27.56.210]) by mc8-f10.law1.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 7 Jul 2003 21:51:34 -0700 Received: from ns3.fatcity.com

RE: concatenated index

2003-07-08 Thread Cary Millsap

[EMAIL PROTECTED] l.com cc: Sent by: Subject: concatenated index [EMAIL PROTECTED] .com 08/07/2003 13:44 Please respond

concatenated index

2003-07-07 Thread Novice DBA

Dear all, I have a basic doubt. I grew up (in Oracle) believing that for the concatenated indexes to be used by a query the ordering of the columns in the where clause was very important. But now I have doubts I have a table test and a composite index on it. CREATE TABLE TEST ( A

Re: concatenated index

2003-07-07 Thread Mark Richard

] l.com cc: Sent by: Subject: concatenated index

Re: concatenated index

2003-07-07 Thread Novice DBA

No more Oracle certifiable DBA From: Mark Richard [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: concatenated index Date: Mon, 07 Jul 2003 20:09:24 -0800 MIME-Version: 1.0 Received: from www3.fatcity.com ([66.27.56.212]) by mc7