Follow the simple steps to index a SQL query that contains 1 join and 1 filter.
First check and index the join columns.
Second check and index the filtered columns.
Lastly fetch the execution plan and confirm the indexes are used.
Watch video How to index a SQL Query online without registration, duration hours minute second in high quality. This video was added by user Ken Kim 01 August 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 38 once and liked it 2 people.