Index Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Travis - 16 Sep 2005 11:32 GMT

Hi ,

I have created 3 fields in for my table , FieldA , B and C all asc order.
What is the diff if I perform the query like :

A) Select * From TableA
Where FieldA = 'A' And FieldB = 'B' And FieldC = 'C'

B) Select * From TableA
Where FieldC = 'C' And FieldB = 'B' And FieldC = 'A'

Do the performance is the same ?

Signature

Travis Tan

Reply to this Message

Brian Lawton - 16 Sep 2005 11:56 GMT

The optimizer should create the same execution plan for both of these
statements therefore performance should be the same.

Signature

--Brian
(Please reply to the newsgroups only.)

> Hi ,
>
[quoted text clipped - 9 lines]
>
> Do the performance is the same ?

Reply to this Message

Travis - 20 Sep 2005 09:15 GMT

Brian ,

Sorry , What I means is I create an index in TableA with FieldA , B and C
all asc order.
What is the diff if I perform the query like :
A) Select * From TableA
Where FieldA = 'A' And FieldB = 'B' And FieldC = 'C'

B) Select * From TableA
Where FieldC = 'C' And FieldB = 'B' And FieldC = 'A'

Travis Tan

> The optimizer should create the same execution plan for both of these
> statements therefore performance should be the same.
[quoted text clipped - 12 lines]
> >
> > Do the performance is the same ?

Reply to this Message

Marcin Pêksa - 27 Sep 2005 12:15 GMT

Same answer:

>The optimizer should create the same execution plan for both of these
>statements therefore performance should be the same.

> Brian ,
>
[quoted text clipped - 26 lines]
>> >
>> > Do the performance is the same ?

Reply to this Message