I know this is not really php but because php and mysql are so close to one another I thought I would ask.... im looking to create an index or indexes on a table...reason being the table can become very large and cumbersome and all of the queries on it use where clauses as well to limit the results. So to improve performance I want to add an index...my question is the following: each of the queries on the table has a common set of variables in the where clause, say $var1 and $var2, but other queries build upon those and look for $var3 as well...example: where $var1=somevalue and $var2=somevalue vs. where $var1=somevalue and $var2=somevalue AND $var3=somevalue can I create one index such as index indexname($var1, $var2, $var3) and use it in all cases even if im only looking at $var1 and $var2?? or do I have to build two separate indexes, one for the two variable case and another for the three variable case??? sorry for not trying this out ahead of time and using explain to see what would happen, I haven't had a chance to look at it. Thanks for any advice in advance. Chad Guilette -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
