MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » July 2014

RE: table indexes



fixed

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.






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

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact