Does Indexes actually make queries fast?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: raj (raj_at_discussions.microsoft.com)
Date: 12/01/04

Next message: Ant: "Re: Repeatable read. What is it exactly..."
Previous message: Kalen Delaney: "Re: Repeatable read. What is it exactly..."
Next in thread: Andrew J. Kelly: "Re: Does Indexes actually make queries fast?"
Reply: Andrew J. Kelly: "Re: Does Indexes actually make queries fast?"
Reply: Mark Allison: "Re: Does Indexes actually make queries fast?"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 30 Nov 2004 20:01:06 -0800

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

Next message: Ant: "Re: Repeatable read. What is it exactly..."
Previous message: Kalen Delaney: "Re: Repeatable read. What is it exactly..."
Next in thread: Andrew J. Kelly: "Re: Does Indexes actually make queries fast?"
Reply: Andrew J. Kelly: "Re: Does Indexes actually make queries fast?"
Reply: Mark Allison: "Re: Does Indexes actually make queries fast?"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: How to fix this Access query
... "John Vinson" wrote in message ... Here is the last post from Raj: ... >>Now if I query this table in an Access query I can only get the characters ...
(microsoft.public.access.forms)
Re: Help with pull only the Mon Q=80=93_Fri_of_previous_week..?=
... >> Nikos, ... >> have is i dont know how to use them in my query. ... >> Thanks Raj ...
(microsoft.public.access.queries)
Re: Does Indexes actually make queries fast?
... Mark Allison, SQL Server MVP ... Looking for a SQL Server replication book? ... raj wrote: ... > timed out) I mean the query did not get timed out as it was before. ...
(microsoft.public.sqlserver.server)
RE: Crosstab column header question
... "Raj" wrote: ... The query shows only the columns header for months that are ... There are time that we will have some future orders and have to ...
(microsoft.public.access.queries)
Re: SQL query produces deferent results randomly!!!
... My guess is that you've got no ORDER BY clause in the query defining ... raj wrote: ... >inconsistace results. ... >below(Correct report) ...
(microsoft.public.sqlserver.programming)