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! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 6 days, processed 214,100,517 queries (397/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]