Query execution plan is an important part of database development process. Many people knows about query execution plan only by definition. So please once go through below link that will provide you how to implement query execution plan.
https://www.simple-talk.com/sql/performance/execution-plan-basics/