From the course: SQL Server 2014: Installation and Administration

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Understanding execution plans

Understanding execution plans - SQL Server Tutorial

From the course: SQL Server 2014: Installation and Administration

Start my 1-month free trial

Understanding execution plans

- Understanding Execution Plans. Now let me tell you this, when you are tuning SQL, that is you are looking at your queries and trying to make them operate faster, one of the first things you're going to want to take a look at is Execution Plans. I say one of the first things, if you're starved for physical resources then Execution Plans are not going to help you much. So the way SQL processes a query, when you submit a T-SQL Statement, Select, whatever, the first thing that happens is the SQL is Parsed, so if you fat fingered something, you misspelled where or whatever, then we're going to pick that up immediately we will throw an error, we're not going to waste our time and we'll wait. So if it passes the Parsing step, we're going to Binding. Binding is when we do name resolution and name resolution will come back now and look over the objects and make sure it can figure out what actually steama.tbl is or whatever it is we're trying to tie into. So now if we pass Parsing, we pass…

Contents