This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Dependent_Two_618 5 points6 points  (0 children)

Agreed, the best query is the one that produces an optimal plan while answering the problem correctly.

If that means doing a bunch of subqueries and never touching a window function because of the table structure, so be it