A 2nd aspect is the scale of the table. An successful and perfectly-indexed use can out-accomplish a ROW_NUMBER with exceptional indexing if the query touches a comparatively modest percentage of the table anxious. https://deweycpks324365.blog5.net/72000093/the-single-best-strategy-to-use-for-join-fast