RE: table indexes

[Jim It <jim_it@xxxxxxxxxxx>]

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.
Jim
> Date: Thu, 10 Jul 2014 20:16:44 +0200
> Subject: table indexes
> From: dfx1@xxxxxxxxxxxxxx
> To: midrange-l@xxxxxxxxxxxx
>
> Hi,
>
> 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.
>
> Thanks
> -- 
> 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,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.