MySQL Forums
Forum List  »  Performance

Queries in creating index
Posted by: Lekha Kumaravellu
Date: October 17, 2023 11:46PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Queries in creating index
139
October 17, 2023 11:46PM
73
October 25, 2023 01:32AM


Sorry, only registered users may post in this forum.

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.