Post reply

can we changge the order in the fields of an index?

  • March 14, 2008 at 8:50 am

    #154198

    Hello

    If a have an index with field1 and field2, is it the same if a do a query:

    select * from table where field1 = x and field2 = y

    or

    select * from table where field2= y and field1 = x

    ?

    is it the same performance?

    THank you

  • March 14, 2008 at 8:52 am

    #789678

    Terry (3/14/2008)

    Hello

    If a have an index with field1 and field2, is it the same if a do a query:

    select * from table where field1 = x and field2 = y

    or

    select * from table where field2= y and field1 = x

    ?

    is it the same performance?

    THank you

    Yes it is, the query optimizer can handle such cases.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply