On Mon, Apr 26, 2004 at 05:17:45PM -0500, Boyd E. Hemphill wrote:
I thought I heard at the conference that the optimizer only uses a one
index per table in a query regardless of the number of indexes on the
table.
Is this true?
Yes.
The only exception is in a UNION, but that's best
-2287
M: (713) 252-4688
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Monday, April 26, 2004 4:23 PM
To: Boyd E. Hemphill
Cc: [EMAIL PROTECTED]
Subject: Re: Optimization and the use of indexes
On Mon, Apr 26, 2004 at 05:17:45PM -0500, Boyd E. Hemphill wrote:
I