I need to reduce response time for query replies.
A table without foreign keys has been queried.
Queries are simple in the form:
SELECT col1, col3,col5 FROM mytable WHERE col1='something' AND col2="somethingelse" AND col4>123 AND col9<56 AND col15='some'
First thing is to set indexes:
1) Should I set a separate index on each column appearing in the query or a compound index that includes all columns being queries. In the latter case is the order of appearance of the columns in the index important?
What would be additional measures to accelerate response time?