title: SQLServer indexing for search critieria
body: <p>In a sqlserver 2008 database we have a table with 10 columns.  In a web application the user interface is designed to allow the user to specify search criteria on some or all of the columns.  The web application calls a stored procedure which dynamically creates a sql statement with only the specified options in the where clause, then executes the query using sp_executesql.</p>
  
  <p>What is the best way to index these columns?  We currently have 10 indexes, each one with a different column.  Should we have 1 index with all 10, or some other combination? </p>