I've got a table with that has 5 fields. Nearly every query I make to
this table is of the form
SELECT * FROM table1 WHERE field1='foo' AND field2=7;
It's always those two exact fields. How should I index this to get
the best performance?
Also, how can I find what other parts of my app would benefit from more indexes?
Thanks,
Pat