If you have a table with columns A & B, and might do a where on A or B,
or an order by A, B, would single column indexes on A and B suffice or
would performance on the order by query be improved by an index on A,B?
Thanks

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.