May 30, 2008 at 8:23 am
Hi Guys,
Iam New To SQL Server, My Question is If we use Excessive joins in Query's the performance will be decreases. so, with disturbing the queries of joins . we have to increase the performance. How to do that?
Please Help Me
Thanks
Pradeep
May 30, 2008 at 8:29 am
create indexes on all the join fields and make sure they are of integer data type.
May 30, 2008 at 8:43 am
Tend to agree with Alex, but you have to examine where each query is slow. What might be making it slow. Look through query plans, etc.
May 30, 2008 at 8:52 am
I'm not sure what you mean by excessive joins. If you are working from an OLTP database proper normalization is going to create the need for many joins, so excessive to me would mean doing joins that are unnecessary. As already noted indexing and examining execution plans will help. Another option is creating either a data warehouse or just some de-normalized tables in your db which you update on a regular basis. One application I worked with we had a daily production table where we rolled up daily production totals on a hourly or less schedule so we had near real time repoting, that performed better than aggregating the data each time someone ran a report.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply