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 |
|
channa
Starting Member
5 Posts |
 Posted - 2008-06-03 : 09:59:15
|
| Hi,I am using a SP which one has lot of Joins(More than 10 tables).For every request from user SP executed, and the DB performance got slow.For this i planned to write a schedule which runs once in an hour to put all the results of SP in to One single table.I thought if the user selects from single table means the performance will increase.I don't know whether this one is a right solution.I am very new to SQL server. Help me for this Problem.Thanks in advance. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Which is best? Select from Joins or Single Table