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 |
|
wki3
Starting Member
1 Post |
 Posted - 2010-07-21 : 14:17:20
|
I have a stored procedure that selects data from a view like 'SELECT somestuff FROM myview'.Would performance be any better if the procedure was written:'Select somestuff FROM (SELECT somestuff FROM atable)'My example is over simplified and seems silly. The actual view selects average, max, and min values from grouped data, and the stored procedure gets those values for one group using parameters. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Performance question