What is an execution plan? When would you use it? How would you view the execution plan?

Question

What is an execution plan? When would we use it? How would we view the execution plan?

Manikavelu Velayutham · Answer

It show you the plan about how your query would be executed internally whether its using the index or not how much cost your select query is like that so many information will be displayed. Based on your query the plan will be generated. Its generally used to tune your query based on the plan shown on the screen. through that you can write a query that could execute very fastly. it will show you the following information Index used Hash Joins Merge Joins Index Seek Index Scan Lookup table to learn the execution plan you should know the above terms first.