From: Jay Blanchard
Date: May 8 2002 3:43pm
Subject: RE: INDEXing on MERGED TABLES
List-Archive: http://lists.mysql.com/mysql/108378
Message-Id: <002501c1f6a7$1d17b9b0$8102a8c0@niigziuo4ohhdt>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

[snip]
When (or after) creating a merge type table, you do need to create all
indexes just like you've created them for your regular tables.
This however will NOT result in physically creating any additional indexes,
but the indexes of the real tables will be used instead.  Therefore no extra
index maintenance is needed.
[/snip]

Cool, that shaved 2 minutes off of the query time by adding indexes to the
MERGEd table definition where the original tables had indexes.

Thanks!

Jay