Re: Queries in creating index

[Lekha Kumaravellu]

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.