Indexes not used in Order by Clause
11g Standard Edition, Amazon RDS cloud
Hi,
The below query is not using index if i included order by clause.I have added a composite index for site_id, role_id and name. but still it is not using the index. Any suggestion is highly appreciated.
select * from user where site_id = 35840 and role_id=2 order by name ASC;