How to see if index is being read "ordered" from DMVs I have a table that is being used in many reporting queries. I would like to know how many times the table is read in an &quot;ordered&quot; way. In the execution plan for clustered index scan one can see if the read is &quot;ordered&quot;. Is this information available other places or is the only solution to search the plan cache?
That data in the query plan only indicates whether the query plan requires on an ordered scan, or whether an allocation-order scan would work too.  Even if the query plan does not require an ordered scan, you normally get one anyway, as allocation-order scans are only allowed under specific circumstances, as Paul White explains all here.
So since this data is about the query plan, not the scan method, it's only available in the query plan.