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 |
|
mavericky
Posting Yak Master
117 Posts |
 Posted - 2011-05-17 : 11:16:59
|
| Hi All,I have a page which shows data in a grid based on the selection of 'place' in the dropdownlist. For each selection in the dropdownlist, to show data, joins are being used between tables. Since, I have 8 'places' in the dropdownlist and for each value, joins are to be used between tables, I think this will reduce the performance of the sql database. Is there any way I can avoid using joins?Thanks,mavericky |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2011-05-17 : 11:23:55
|
| Sql Server loves JOINs. You should not avoid them. If you have performance problems post the (scripted out) table structures/indexes and the statement you're using.Be One with the OptimizerTG |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Avoid using joins