It is a property of Mysql that such a query will benefit greatly from a composite index. So I would not consider anything else without having tried this.
Am Thursday 11 November 2004 16:29 schrieb John Smith: > On Thu, 2004-11-11 at 14:59, Victor Pendleton wrote: > > If you build the composit indexes as suggested, does your performance > > improve? > > Erm, do you think it would? Its just that with such a large table and it > being compressed it takes ages? -- Stefan Kuhn M. A. Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de) ZÃlpicher Str. 47, 50674 Cologne Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786 My public PGP key is available at http://pgp.mit.edu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
