First page Back Continue Last page Graphics

Hash versus Nested Loops

Notes:

The same query using a nested loops join causes almost twice as many logical I/O’s. Remember, logical I/O’s are memory latches on blocks; this costs CPU time and reduces scalability.