• 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: explain plan

July 12, 2022 Uncategorized

Digging deeper into SQL under APEX

For the many cases, simply having an EXPLAIN PLAN function will do the job when it comes to tuning SQL.

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.

Tweets by connor_mc_d

    Top Posts & Pages

    • How to do a GRANT on an entire schema
    • Why I blog
    • Why you keep getting "ORA-01653: unable to extend table"
    • Adding APEX 23.1 to your Database Free VM
    • No more stale statistics in 19c
    • How to TREAT data in a CLOB as JSON
    • Implementing dynamic partitions AND subpartitions
    • Bringing Multimedia back into 19c!
    • INITRANS grabs a little more space
    • How to generate random unique values
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 864 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
     

    Loading Comments...