Questions about indexes

["Pat Maddox" <pergesu@xxxxxxxxx>]

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