Advertisement

Optimizing Joins

Chapter
  • 287 Downloads

Abstract

When a SQL statement references several tables, the query optimizer has to determine, in addition to the access path for each table, which order the tables are joined in and which join methods are used. The goal of the query optimizer is to minimize the amount of processing by filtering out unneeded data as soon as possible.

Keywords

Hash Table Nest Loop Work Area Execution Plan Query Optimizer 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Christian Antognini 2008

Personalised recommendations