Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

How to reduce the joins in sql querry Expand / Collapse
Author
Message
Posted Wednesday, November 20, 2013 3:36 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:46 AM
Points: 2,734, Visits: 943
10 or more joins are not a problem.
Bad normalized/designed data structure and no properly indexed tables are.

Just try to outer join two big tables by no indexed columns or using implicit data type conversion and you ill fell the pain.
(inner) joining 10 huge (well designed) tables by (tunned) indexed columns ill run smoothly.
Post #1515975
Posted Wednesday, November 20, 2013 8:52 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 6:44 AM
Points: 4,400, Visits: 6,260
jcb (11/20/2013)

...(inner) joining 10 huge (well designed) tables by (tunned) indexed columns ill run smoothly.


Until you have some data value skew, in which case the probability of getting screwed increases with increasing numbers of joins


Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1516091
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse