Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> indexes
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFB9BD.5D9C4786
Content-Type: text/plain;
charset="ISO-8859-1"
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
------_=_NextPart_001_01BFB9BD.5D9C4786
Content-Type: text/html;
charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DISO-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>indexes</TITLE>
</HEAD>
<BODY>
<P><FONT COLOR=3D"#800000" FACE=3D"Bookman Old Style">I know this issue =
has been discussed before but I can't find the answer in my list =
archives.</FONT>
</P>
<P><FONT COLOR=3D"#800000" FACE=3D"Bookman Old Style">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?</FONT></P>
<P><FONT COLOR=3D"#800000" FACE=3D"Bookman Old Style">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)</FONT>
</P>
<P><FONT COLOR=3D"#800000" FACE=3D"Bookman Old Style">Thanks in =
advance!</FONT>
<BR><FONT COLOR=3D"#800000" FACE=3D"Bookman Old Style">Val</FONT>
</P>
<P><B><I><FONT COLOR=3D"#000080" FACE=3D"Bookman Old Style">Valerie H. =
Webber</FONT></I></B><I></I><FONT COLOR=3D"#000000" FACE=3D"Arial"><BR>
</FONT><FONT COLOR=3D"#000080" SIZE=3D1 FACE=3D"Comic Sans =
MS">Management Systems Designers, Inc</FONT><FONT COLOR=3D"#000000" =
FACE=3D"Arial"><BR>
</FONT><FONT COLOR=3D"#000080" SIZE=3D1 FACE=3D"Comic Sans =
MS">Valerie.H.Webber_at_m1.irs.gov</FONT><FONT COLOR=3D"#000000" =
FACE=3D"Arial"><BR>
</FONT><FONT COLOR=3D"#000080" SIZE=3D1 FACE=3D"Comic Sans =
MS">704-569-1002 x107</FONT><FONT COLOR=3D"#000000" FACE=3D"Arial"> =
</FONT>
Received on Tue May 09 2000 - 08:49:17 CDT
![]() |
![]() |