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 |
|
k_cire0426
Yak Posting Veteran
63 Posts |
 Posted - 2010-08-11 : 23:54:55
|
| Is it normal to query a table with 500K records in almost 2 minutes? |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-12 : 01:37:39
|
it all depends on what your query does.if you are running a complex query consisting of subqueries, a lot of joins etc, one must consider what is 2 minutes in this case.if you are running a normal select * from my table , ask yourself why? :)otherwise i suggest you to create indexes against the table for better performance. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-12 : 14:08:44
|
| also a major factor that affects performance is presence of proper indexes on table columns------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Querying a table is too slow.