Re: Index used in query?

From: Chris Weiss <weisschr_at_pilot.msu.edu>
Date: Mon, 2 Aug 1999 16:34:30 -0400
Message-ID: <7o4vdo$891$1@msunews.cl.msu.edu>

Read up on the explain plan command and you will see for yourself. My initial response is "yes" but it depends on other factors such as your optimizer settings, the size of the tables, etc.

Christopher Weiss
Professional Services Division
Compuware Corporation

Clive Walden <clivew_at_abac.com> wrote in message news:37a6fb0d.175835257_at_news1.abac.com...
> Can the SQL engine use both index1 and Index2 in the following
> scenario?
>
> Table1
> Field1
> Field2
> Field3
> Index1 on Field1,Field2
>
> Table2
> FieldA
> Field1
> Field2
>
> Index2 on FieldA,Field1,Field2
>
> Query
> Select .....
> From Table1 A, Table2 B
> Where (A.Field1 = B.Field1 )
> and ( A.Field2 = B.Field2 )
> and (B.FieldA = 1234 )
>
> Thanks - Clive
Received on Mon Aug 02 1999 - 15:34:30 CDT