here is my doubt: I´m working with a table which is accessed in read mode several times with different queries. It is not possible to create an index for each query, because there would be too many indexes.
These queries have several predicates in the WHERE clause like:
SELECT FIELD1, FIELD2
WHERE FIELDA = XXX AND
FIELDB = BBB AND
FIELDC = ZZZ AND
FIELDD = AAA
My particular question is:
- In a WHERE clause of a SELECT statement, should the predicates follow the same order of the fields in the table to be more efficient?