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
If I gave you a telephone book and asked you to tell me how many distinct street names are present
This question got posed on Twitter today I answered briefly on Twitter, but I thought I should give it some
Yes it’s SCBT day here in Perth! SCBT = Silly Click Bait Title This post is just a cautionary tale
Just a quick revisit on an old topic so I could link to this post in a Stack Overflow discussion.
We’ve (hopefully) all had it drummed into us enough times – you cannot assume the order of results from queries
Within a CONNECT BY statement, you can order siblings, that is, under a particular branch of the hierarchy, the child
Whenever you have the need to use the DISTINCT keyword, its worth just pausing for a second, and making sure