Subject Index
Author Chooi-Ting
Base on the query below:

select column1, column2, column3, column4, column5
from tableA
where column 3 = value1
and column4 = value2
and column5 = value3
order by column1, column2;

if I were to create the index key, what is the sequence of the index
field ?
-> create index index1 on tableA (column3, column4, column5)

do we need to include column1 and column2 to the index ?

please advise.

rgds, chooi ting