Is there a direct way to know if a merry-go-round scan happened?
3
votes
1
answer
174
views
In the [docs](https://learn.microsoft.com/en-us/sql/relational-databases/reading-pages?view=sql-server-ver16)
it says we can share index scans (Advanced Scanning).
Now [here](https://www.mssqltips.com/sqlservertip/4472/sql-server-enterprise-advanced-scan-aka-merrygoround-scan/)
they used wait stats and statistics
and i did not find an extended events session that could directly identify it.
The question is - how can i know that an advanced scan has been used? I know about ordered false property, but that just says that it did not use the order in the index key?
Asked by Suleyman Essa
(167 rep)
Feb 21, 2025, 11:09 AM
Last activity: Feb 23, 2025, 07:14 AM
Last activity: Feb 23, 2025, 07:14 AM