Add ORDER BY to make ANY query faster
Yes it’s SCBT day here in Perth! SCBT = Silly Click Bait Title This post is just a cautionary tale
Tag: sorting
ROWNUM and ORDER BY
Just a quick revisit on an old topic so I could link to this post in a Stack Overflow discussion.
Never rely on an assumed order
We’ve (hopefully) all had it drummed into us enough times – you cannot assume the order of results from queries
A little known ORDER BY extension
Within a CONNECT BY statement, you can order siblings, that is, under a particular branch of the hierarchy, the child
Mr DISTINCT might not be your friend
Whenever you have the need to use the DISTINCT keyword, its worth just pausing for a second, and making sure
