Does Indexes actually make queries fast?

I had a query most of the time got "timed out". Add some indexes things did
not get any defferent. After remove the indexes it work fine (rarely got
timed out) I mean the query did not get timed out as it was before. Does
Indexes actually make queries fast?
rajRaj,
Don't take this the wrong way but it's pretty obvious that you know little
about a modern relational database. That is fine in that no one is born
with this knowledge. But I really do suggest before you start to developed a
database and or db application that you do a little reading on the subject.
Or possibly take a class on SQL Server. It will make your life much easier
and will save you lots of time and frustration in the long run. To answer
your question yes they do make queries faster when done correctly. Without
indexes a modern database would be mostly useless.
Andrew J. Kelly SQL MVP
"raj" <raj@.discussions.microsoft.com> wrote in message
news:B80E0BDF-72D1-4DA2-BEBB-1E23E39B6C25@.microsoft.com...
>I had a query most of the time got "timed out". Add some indexes things did
> not get any defferent. After remove the indexes it work fine (rarely got
> timed out) I mean the query did not get timed out as it was before. Does
> Indexes actually make queries fast?
> raj
>|||"raj" <raj@.discussions.microsoft.com> wrote in message
news:B80E0BDF-72D1-4DA2-BEBB-1E23E39B6C25@.microsoft.com...
> I had a query most of the time got "timed out". Add some indexes things
did
> not get any defferent. After remove the indexes it work fine (rarely got
> timed out) I mean the query did not get timed out as it was before. Does
> Indexes actually make queries fast?
Done right.. yes.
Done wrong, no.

> raj
>|||raj,
If they are implemented badly they will make your server SLOWER. I agree
with Andrew.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
raj wrote:
> I had a query most of the time got "timed out". Add some indexes things di
d
> not get any defferent. After remove the indexes it work fine (rarely got
> timed out) I mean the query did not get timed out as it was before. Does
> Indexes actually make queries fast?
> raj
>