Queries in creating index
Hello Everyone,
I have a doubt in creating index which is my sql query contains id, name, age columns in where clause , so i am trying to create index on this respective columns but my index is not at all using the sql query. so i added one column which is not using my sql query now its started using the index.
may i know the reason behind that.
Subject
Views
Written By
Posted
Queries in creating index
314
October 17, 2023 11:46PM
197
October 25, 2023 01:32AM
Sorry, you can't reply to this topic. It has been closed.
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.