• About
  • All Posts
  • The Podcast!
  • Playlists
  • Golden Oldies
Skip to content

Learning is not a spectator sport

  • 30 second guide to India
  • About
  • Archives
  • Golden Oldies
    • First match
    • Smart DBA
  • Playlists
  • The Podcast!

Tag: sorting

August 17, 2020 Uncategorized

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

Continue reading

March 4, 2020 Uncategorized

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

Continue reading

November 7, 2018 Uncategorized

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

Continue reading

February 28, 2018 Uncategorized

ROWNUM and ORDER BY

Just a quick revisit on an old topic so I could link to this post in a Stack Overflow discussion.

Continue reading

February 16, 2016 Uncategorized

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

Continue reading

January 19, 2016 Uncategorized

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

Continue reading

August 15, 2015 Uncategorized

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

Continue reading

Over 500 posts …

Let’s connect

  • View connor_mc_d’s profile on Twitter
  • View connor_mc_d’s profile on Instagram
  • View connor-mcdonald-australia’s profile on LinkedIn
  • View UCVN7PnJnuKQ65QLmWjFvhiw’s profile on YouTube

Hi I'm Connor McDonald. I love playing with and exploring the Oracle database. But most of all I like seeing people succeed with the technology.
 
Subscribe for new posts by email.

Top Posts & Pages

  • How to do a GRANT on an entire schema
  • Version 7 was so much better...
  • The Fractional Part of a TIMESTAMP. Be careful.
  • Why you keep getting "ORA-01653: unable to extend table"
  • How to TREAT data in a CLOB as JSON
  • Connection shortcuts with a wallet
  • A little known RI clause
  • No more stale statistics in 19c
  • Automatically generate audit capture for tables
  • MERGE and ORA-30926
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 810 other followers
    • Already have a WordPress.com account? Log in now.
    • Learning is not a spectator sport
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar