 |
Return Create A Forum - Home |
 |
--------------------------------------------------------- |
|
ExcelSoft Database Professionals |
 |
https://esdbp.createaforum.com |
|
--------------------------------------------------------- |
|
***************************************************** |
|
Return to: All you need to know about "Execution Plans" |
|
***************************************************** |
|
#Post#: 23-------------------------------------------------- |
|
Why should I know about "Execution Plans?" |
|
By: Yasub_exceldbp Date: March 12, 2014, 2:00 am |
|
--------------------------------------------------------- |
|
DB Developer: "Yasub, I already have so much to do on a daily |
|
basis, so many stored procedures to write, Code Reviews pending, |
|
Developers/Team Leads/Managers are sitting on my head! Why |
|
should i spend my time on knowing about "Execution Plans?", How |
|
will it help me? " |
|
Well, Every time I learn something new, before learning it, I |
|
have the same question in my mind, as above, "Why should I learn |
|
it, How will it help me?". So, if you have entered this board |
|
and you are having the same question, then I feel its a very |
|
valid question!!! |
|
So, let me try and answer it for you. |
|
Imagine that you are made the Manager of a factory that |
|
processes milk. What you do is, you go daily to the Factory at 8 |
|
AM, you make sure all the workers have arrived, then you go to |
|
your office, sign all the relevant documents, make payments of |
|
daily wages to the workers and at 5 PM, you leave. Life is good! |
|
:) |
|
Until one day, one of the main processing machine is suddenly |
|
taking a long time to process a small amount of milk! The |
|
engineer is out of station and as the factory is in a remote |
|
location, to get another engineer will take at least a day! |
|
Now what? |
|
Well, you have no choice! Put both hands on your head and wait! |
|
A smart Manager, would have understood, how each of these |
|
machines actually work internally, he/she would have learnt the |
|
art from the Engineer, so that during crisis, That knowledge |
|
would be of help! Great help! |
|
The same thing applies to the queries you write. You are the |
|
Manager of these queries. If you just write queries, without |
|
understanding how they are "internally executed", then when this |
|
query takes several hours to execute, you wouldn't know what to |
|
do! Put both hands on your head and wait? . |
|
DB Developer: "Hmmm, So i can find out how a query is internally |
|
executed, by looking at an Execution Plan?" |
|
Me: "Yes!!! :) " |
|
DB Developer: "Cool!! But why all this fuss? Why does SQL Server |
|
need to create an "Execution Plan" to execute a query? Why can't |
|
it just execute the query? Isn't life already tough? Why make it |
|
tougher???" |
|
Me: "Good question!, We will talk about that in the next post." |
|
Stay "tuned" for more.. :) |
|
You can reply to this post, in case you have any |
|
questions/suggestions. |
|
You can also find the same article here: |
|
http://allaboutexecutionplans.blogspot.in/ |
|
Thank you. |
|
-Yasub |
|
#Post#: 67-------------------------------------------------- |
|
Re: Why should I know about "Execution Plans?" |
|
By: vinutha_exceldbp Date: May 21, 2014, 1:07 am |
|
--------------------------------------------------------- |
|
Intresting :),when is the next post?,am eagerly waiting |
|
#Post#: 68-------------------------------------------------- |
|
Re: Why should I know about "Execution Plans?" |
|
By: Yasub_exceldbp Date: May 21, 2014, 1:32 am |
|
--------------------------------------------------------- |
|
Thank you Vinutha, your interest is appreciated :) . If you |
|
liked the post, you can click on the "applaud" link, next to the |
|
post. Thank you! |
|
Next post, soon! :) |
|
-Y |
|
***************************************************** |
