Re: MYSQL INDEX CREATION...

2003-08-11 Thread Jeremy Zawodny
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 INDEX CREATION...

2003-07-16 Thread Cory Lamle
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 on