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 |
|
mvanwyk
Yak Posting Veteran
99 Posts |
 Posted - 2009-06-18 : 09:16:27
|
| Hi Guys.I have a DB that contains about 4 mil rows and i want to run the following query on it every 5 min's will this impact the servers performance in anyway?The amount of rows increase daily by about 30000select top 1 createdate from [Message] Order By createdate DESCPlease also note that we have several other things happening on this table as well.Will this lock any records?Any response would be apprecietaed |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-18 : 09:23:59
|
Do you need only this createdate?Have you tried then to do: select max(createdate) as createdate from [Message]?Indexes?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Performance Impact from query