troubleshooting Question

SQL Server - how to increase query speed of simple query

Avatar of JElster
JElsterFlag for United States of America asked on
Microsoft SQL Server 2008
10 Comments5 Solutions375 ViewsLast Modified:
Hi..
I have a simple stored procedure that looks like this

SELECT * FROM CUSTOMERS ORDER BY LASTNAME , FIRSTNAME

The customer table has over 100 fields.
It returns 20K records, I have an index on lastname, firstname.
The execution plan say 46% Sort, 54% table scan.
It appears to take 25 -45 seconds to run . When called and traced in Activity Monitor from a web app.  In Query analyzer it takes 10  seconds. Any suggestions how I can speed it up.
thx
ASKER CERTIFIED SOLUTION
Nem Schlecht
IT Engineering Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Top Expert 2009

The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.

Join our community to see this answer!
Unlock 5 Answers and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 5 Answers and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros