Order of columns in where clause to use index?

[tamilselvan]

In order to use Index, the order of columns in where clause should be same as Indexed columns.

Otherwise, use Index Name in the HINT clause in the Select statement.