Faster DISTINCT operations in 19c
If I gave you a telephone book and asked you to tell me how many distinct street names are present
Tag: sorting
Nulls are not stored in indexes … most of the time
This question got posed on Twitter today I answered briefly on Twitter, but I thought I should give it some
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
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
Learning is not a spectator sport 