IT Web Feeds » Ben Nadel ColdFusion And Web Development Feed @ BenNadel.com » Performance Of LEFT OUTER JOIN Insert vs. INNER JOIN Delete Statement

Feeds

4226 items (4226 unread) in 12 feeds

• Developer Fusion Recent Articles & Tutorials (62 unread)

WebDevelopment (3842 unread)

• Open Source Web Development Tutorials - RSS Feeds (170 unread)
• 4GuysFromRolla.com Headlines (7 unread)
• ASP.NET Daily Articles (262 unread)
• SitePoint.com (10 unread)
• ScottGu's Blog (38 unread)
• C-Sharpcorner Latest Articles (2512 unread)
• The Code Project Latest Articles (833 unread)
• Developer Tutorials (10 unread)

PHP (23 unread)

• Good PHP Tutorials - New Tutorials (23 unread)

ColdFusion (191 unread)

• Ben Nadel ColdFusion And Web Development Feed @ BenNadel.com (191 unread)

MicrosoftExchangeServer (108 unread)

• MSExchange.org (108 unread)

Ben Nadel ColdFusion And Web Development Feed @ BenNadel.com

• August 19, 2011
• 

  Performance Of LEFT OUTER JOIN Insert vs. INNER JOIN Delete Statement

  Posted: August 19th, 2011, 10:06am CDT

  When it comes to database queries, the only kind of JOIN that I like to perform with SQL is an INNER JOIN. They are wicked fast and always satisfying. Any time that I have to figure out which records don't have relationships, it means that I have to do a LEFT OUTER JOIN; this is always depressing and often slow and I try to avoid it as much as possible. That's why I ended up trying something a bit counterintuitive the other day. I was in a situation where I needed to populate one table (T) wi ... Read More »