Thinking outside the box

Patron Saint of Lost Yaks
posts - 203, comments - 734, trackbacks - 4

My Links

Advertisement

News

Archives

Post Categories

Finding records in one table not present in another table II

In previous topic here
http://weblogs.sqlteam.com/peterl/archive/2007/09/20/Finding-records-in-one-table-not-present-in-another-table.aspx

Michael Valentine Jones suggested an alternative route to get all records from one table not found in another.

Here are the results (including my suggestion with only MIN(t1) = 1 as MVJ2)

SQL 2000   CPU DURATION READS WRITES
Original 1781 1783 30667 0
Peso 1 0 0 29      0
Peso 2 0        0 31      0
Peso 3 0        0 16      0
MVJ 1 15       16 16      0
MVJ 2 0        0 16      0
 
 
SQL 2005    CPU DURATION READS WRITES
Original 19563 19763 98546 0
Peso 1 16 158 14114      0
Peso 2 16 128 28      0
Peso 3 16 119 28      0
MVJ 1 31 120 28      0
MVJ 2 15 115 28      0
 

Print | posted on Monday, September 24, 2007 9:04 AM | Filed Under [ Optimization ]

Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET