When you execute a query, the database server has to figure a lot of things out. For even the simplest queries, there are usually several possible ways to get the job done.
The post What Is a Cost-Based Optimizer? appeared first on SQLServerCentral.