indexes

From: Webber Valerie H <Valerie.H.Webber_at_irs.gov>
Date: Tue, 9 May 2000 09:49:17 -0400
Message-Id: <10492.105230@fatcity.com>

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>

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 - 08:49:17 CDT