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 |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2002-08-29 : 22:06:03
|
| Hi Folks,I have a query which has a a large number of joins. This was giving slow performance. Hence the tables were denormalized. Is this the only strategy to improve performance is by denormalizing the tables?What other factors need to be considered befor denormalizing tables?Thank youByeRamdasRamdas NarayananSQL Server DBA |
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2002-08-29 : 22:22:49
|
| Did you try creating views? They gave my queries, which also involved many joined tables, a tremendous performance boost.Sarah Berger MCSD |
 |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2002-08-29 : 23:05:03
|
| Try running an execution plan on the query to see where the bottlenecks are. You can then tune your indexes (indices?) to achieve better performance. Views will help a bit, mainly because the server doesn't have to work out an execution plan every time it runs the query. Tim |
|
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-08-30 : 09:40:16
|
| The other strategies mentioned should be tried first. You may also either denormalizing or consider writing reporting tables that are populated periodically. It depends on if you need absolute real time queries or not. |
|
|
|
ramdas
Posting Yak Master
181 Posts |
Posted - 2002-08-30 : 09:56:37
|
| Hi folks,Thanks a lot for your inputs. I will try out the strategies mentioned.ByeRamdasRamdas NarayananSQL Server DBA |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
|
|
|
|
|
Denormalizing for Performance.