B\Batch 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.)
To minimize the amount of time it takes to execute usp_GetFutureSessions, two strategies should be considered: improving the indexing to avoid scans when seeks can be used, and ensuring that the query is optimized to use the indexes effectively. Changing line 02 of Indexes.sql to include (DeliveryTime, SessionID) will help ensure that the index is useful for the query conditions and can support seek operations efficiently. Additionally, modifying the query in Procedures.sql to filter appropriately with WHERE GETDATE() < DeliveryTime, ensures that the query uses the index efficiently by excluding past sessions and focusing only on future sessions, leading to quicker execution times.
BCE is the answer
C also is in the answer because it´s make a covering index.
B ERROR: Incorrect WHERE clause for filtered index 'IX_Sessions' on table 'dbo.Sessions'. C Cannot use SEEK because DeliveryTime is not ther first column of index Should be A and E