I have a query like SELECT * FROM TABLE WHERE FIELD1='bla bla' AND FIELD2='etc etc'
1. Which is better, creating an index with 2 colums (FIELD1, FIELD') or creating 2 separate indexes for each field?
2. If is better to create 1 index with 2 columns and let's say FIELD1 is the primary key of the table what should I do (Since there is already a unique index for FIELD1) ?