Most Popular Query Optimizer

About SQL Server Halloween Protection

Halloween protection refers to a problem that appears in certain update operations and was found more than 30 years ago by researchers working on the System R project at the IBM Almaden Research Center. The System R team was testing a query optimizer when they ran a query to update the salary column on an […]

Read More

How the SQL Server Query Optimizer Works

In this article, we’ll briefly describe the inner workings of the query optimization process, which extends both before and after the query optimizer itself. The diagram in Figure 1 shows the major phases of the query processing, and each phase will be explained in more detail in the remaining sections of this chapter. Figure 1 The query-processing […]

Read More