how to optimize sql server table for faster response?
Posted
by
Thomas
on Stack Overflow
See other posts from Stack Overflow
or by Thomas
Published on 2011-01-01T10:26:16Z
Indexed on
2011/01/01
10:53 UTC
Read the original article
Hit count: 187
sql-server-2005
i found a in a table there are 50 thousands records and it takes one minute when we fetch data from sql server table just by issuing a sql. there are one primary key that means a already a cluster index is there. i just do not understand why it takes one minute. beside index what are the ways out there to optimize a table to get the data faster. in this situation what i need to do for faster response. also tell me how we can write always a optimize sql. please tell me all the steps in detail for optimization.
thanks.
© Stack Overflow or respective owner