What should you do?

BBatch 1
While testing usp.GetFutureSessions, you discover that IX_Sessions is accessed by a scan rather than a seek.
You need to minimize the amount of time it takes to execute usp_GetFutureSessions.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)


A. Option A
B. Option B
C. Option C
D. Option D
E. Option E
F. Option F

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.