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 |
|
jxxdeep
Starting Member
1 Post |
 Posted - 2011-03-29 : 23:19:22
|
| I'm facing this weird issue where a simple SELECT statement works fine for most of the rows in this table but for few selected rows (mostly the new ones) takes forever to read. It's normal size table with 2200+ rows now and it has a clustered unique primary key set.SELECT statement reads the older records very fast but slows with most new ones. Any idea what's happening here and how can I fix this? Thanks much. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-03-30 : 02:36:14
|
can you show us your select statement ? How do you select from the older and new records ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Weird - Very slow read for certain table rows