Hi,
to get the best query performance is it necessary to create a separate
index on a column which is already part of an another index?
Example:
Table TEST:
COL1
COL2
COL3
The PRIMARY KEY consists of COL1 and COL2. But if I run a query only on
the not unique COL1 is it better for the query performance to have a
separate index or is the existence of the primary key sufficient?
Greetings,
Andreas