Should the order of the columns in the where clause be the same order as the index, so the index is used?
e.g.
A table called test, with the following columns:
test_id
user_id
user_name
date_submitted
etc.
There is an index on test_id and user_id, in that order.
If I now do a 'select * from test where user_id=? and test_id=?, will it use the index. I have always been told that when using where clauses the columns order must reflect the index order, but my colleague is now telling me this is not true, and you can now specify any order in the where clause.
I am using Oracle version 8.1.5.