MS SQL Server - SQL Server Query Execution Plan

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL Server Query Execution Plan

Praveen

2006-03-10, 3:23 am

How the SQL Server optimizer choose determines which Execution plan is
best plan?.

Tibor Karaszi

2006-03-10, 3:23 am

Basically, it estimates cost for different alternatives and pick the one with the lowest cost.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

"Praveen" <apveen@gmail.com> wrote in message
news:1141973453.706898.295370@p10g2000cwp.googlegroups.com...
> How the SQL Server optimizer choose determines which Execution plan is
> best plan?.
>

Sponsored Links