It is absolutely not necessary to build any indexes which already have the same key fields in the the same order in another index. The optimizer looks and sees which index most closely matches the criteria laid out in the SQL statement and will use the one with the lowest cost.
Date: Thu, 10 Jul 2014 20:16:44 +0200
Subject: table indexes
From: dfx1@xxxxxxxxxxxxxx
To: midrange-l@xxxxxxxxxxxx


I have a table with an index already on Columns 1, 2, 3 and 4.

Now I've been told we need another one on Columns 1, 2 and 3.

Is that necessary? I don't see why.

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives

This thread ...


Return to Archive home page | Return to MIDRANGE.COM home page