Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scantoria
Starting Member
15 Posts |
 Posted - 2010-03-23 : 15:28:02
|
| I have a database with 3 million records. I have a web application with simple select statement queries. The result takes too long and I sometimes get a time out error. I am using a stored procedure for my queries. Is there a way to get the results faster?Thanks.Stephen Cantoriascantoria@msn.com |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-23 : 15:59:22
|
Look for INDEX.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
scantoria
Starting Member
15 Posts |
Posted - 2010-03-23 : 16:48:09
|
| if the database table is flat, how would indexing help?Stephen Cantoriascantoria@msn.com |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-03-23 : 16:50:54
|
| [url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/[/url][url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/[/url]--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Is there a way to optimize a query?