MySQL Forums
Forum List  »  Performance

Re: Queries in creating index
Posted by: Lekha Kumaravellu
Date: October 25, 2023 01:32AM

Lekha Kumaravellu Wrote:
-------------------------------------------------------
> Hello Everyone,
>
>
> I have a doubt in creating index i.e., the sql
> query contains id, name, age columns in where
> clause , so i am trying to create index on this
> respective columns but the query is not at all
> using the index. so i added one column which
> is not using the sql query now its started using
> the index.
>
> may i know the reason behind that.

Options: ReplyQuote


Subject
Views
Written By
Posted
176
October 17, 2023 11:46PM
Re: Queries in creating index
101
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.