On Wed, Jul 16, 2003 at 03:49:51PM -0700, Cory Lamle wrote:
> Contents are Direct Alliance Corporation CONFIDENTIAL
> -
> I have a table with 10 cols. 8 of which all need to be searched on
> independently of each other.
>
> Does creating 8 separate indexes for that table affect the speed of how
> mysql searches each index?
>
> In other words would keeping my indexes to only 4 separate indexes be
> anymore efficient on a table search than If I had 8 separate ones?
It's hard to say without a concrete example to look at. Can we see
the proposed table structure and a sample query or two?
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
MySQL 4.0.13: up 6 days, processed 214,100,517 queries (397/sec. avg)
