Surely that depends upon who or what is doing the telling? If it's the
SQL optimizer telling you then it might have a good reason. If it's your
CEO, then the correct response is, "Yes ma'am!"

Trevor Briggs
Lincare, Inc.
(727) 431-1246

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Sent: Thursday, July 10, 2014 2:17 PM
To: Midrange Systems Technical Discussion
Subject: table indexes


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.


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