does sequence of columns in where condition matters the sequence of composite key? in Oracle Database
No, it will not matter. Make sure: 


Data types are same in both tables
All columns are indexed  Index
Index statistics are not stale.

SELECT stale_stats FROM user_ind_statistics
WHERE index_name = upper('&amp;index_name');