TheSQLServerQueryOptimizerisacost-basedoptimizer.Itanalyzesanumberofcandidateexecutionplansforagivenquery,estimatesthecostofeachoftheseplans,andselectstheplanwiththelowestcostofthechoicesconsidered.Indeed,giventhattheQueryOptimizercannotconsidereverypossibleplanforeveryquery,it