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 Ba

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
2227d ago – Paul White
16
3
This room is frozen.
Public: anyone may enter and talk

Explicit write access

Even when this room is read-only or their reputation is too low, these users will be able to talk in this room. Users with insufficient reputation to chat have been granted write access to this room by a chat moderator.