Discussion on question by Vladimir Baranov: ROW_NUMBER() OVER (PARTITION BY B,A ORDER BY C) doesn't use index on (A,B,C)

Discussion on question by Vladimir Baranov: ROW_NUMBER() OVER (PARTITION BY B,A ORDER BY C) doesn't use index on (A,B,C)

Database Administrators

Imported from a comment discussion on https://dba.stackexchange.com/questions/141999/row-number-over-partition-by-b-a-order-by-c-doesnt-use-index-on-a-b-c

sql-server sql-server-2008 sql-server-2014
first message2019-06-21
last message2213 days ago
join this room
view transcript

16
3

Owners of this room