Re: indexes

From: Rajagopal Venkataramany <rajagopalvr_at_hotmail.com>
Date: Tue, 09 May 2000 15:19:16 GMT
Message-Id: <10492.105242@fatcity.com>

Hi,

  In such cases, index on A will be used. The value of C here does   not help the optimizer anyway.

Regards
Rajagopal Venkataramany

----Original Message Follows----
From: Webber Valerie H <Valerie.H.Webber_at_irs.gov> Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: indexes
Date: Tue, 09 May 2000 07:09:59 -0800

I know this issue has been discussed before but I can't find the answer in my list archives.

If you have a composite index on a table consisting of columns A,B,C in that order, will the index be used if I have a query/where clause on columns A and C?

I know that it will if I query on A alone or A,B or A,B,C but I can't find documentation about A and C (no B)

Thanks in advance!
Val

Valerie H. Webber
Management Systems Designers, Inc
Valerie.H.Webber_at_m1.irs.gov
704-569-1002 x107

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com Received on Tue May 09 2000 - 10:19:16 CDT