Hey Kevin, What if the execution plan on the Stored proc doesn't show up any suggestions on Missing indexes? Should I think that there is no scope for the index or am I missing some setting or something to have it in the plan.
That is possible. Also, it may be using an index that could be improved, or the tables are so small SQL just scans them instead of indexes. No way to tell without knowing a lot more. If you need help with a specific issue, pease post on MSDN forums or DBA.stackexchange.com
Very helpful video Kevin ..Keep sharing your knowledge.
Thanks, will do!
Really like your way of explaining things! Keep posting such stuff, helps alot!
Really informative. Thank you!
Glad you enjoyed it!
This was easy to follow and very helpful. Thanks Kevin! !
@Jaxon Coen you find what you were looking for?
Thank you Kevin, I am new to DBA and these are very helpful.
Glad I could help :)
Wow Kevin you made this look really easy..thumps up
Glad it helped :)
Great video, thanks!
Glad you liked it!
Hey Kevin, What if the execution plan on the Stored proc doesn't show up any suggestions on Missing indexes? Should I think that there is no scope for the index or am I missing some setting or something to have it in the plan.
That is possible. Also, it may be using an index that could be improved, or the tables are so small SQL just scans them instead of indexes. No way to tell without knowing a lot more. If you need help with a specific issue, pease post on MSDN forums or DBA.stackexchange.com
Thanks 👍