RE: indexes

From: Alvarez, Carlos <CAlvarez_at_uniFON.com.ar>
Date: Tue, 9 May 2000 11:27:40 -0300
Message-Id: <10492.105235@fatcity.com>

Hi Valerie

Assuming that there is no other index on A.C, the index will be used (or not, it depends on the CBO and the table statistics ), but only for column A (equal to use only column A).

Carlos

> ----------
> De: Webber Valerie H[SMTP:Valerie.H.Webber_at_irs.gov]
> Responder a: ORACLE-L_at_fatcity.com
> Enviado el: Martes 9 de Mayo de 2000 12:09
> Para: Multiple recipients of list ORACLE-L
> Asunto: indexes
>
> 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
Received on Tue May 09 2000 - 09:27:40 CDT