• 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: indexes

November 23, 2022 Uncategorized

Google-like search for your entire application

I published a video today showing how to use a Text index to pick up search terms from multiple tables

Continue reading

a non-descript blob of red paint
April 6, 2022 Uncategorized

DBMS_METADATA for INDEXES

Just a quick tip on using DBMS_METADATA that caught me out the other day. If you have a table and

Continue reading

two hands shuffling a deck of cards in close up
March 22, 2022 Uncategorized

When re-ordering columns is warranted

Nearly 10 years ago(!!!) I blogged about how you can toggle columns to invisible and back again as a means

Continue reading

congested traffic across 4 lanes
November 14, 2021 Uncategorized

The big table dilemma – what about transaction rates?

Yesterday I posted some demonstrations of the impressive power of indexes in relational databases for data retrieval even when those

Continue reading

a truck overfilled with cut logs driving on the highway
November 13, 2021 Uncategorized

When does a table become too big?

I happened across an interesting thread on Twitter today which posed the question about when you should intervene with alternative

Continue reading

September 9, 2021 Uncategorized

Can you solve this blocksize puzzle?

Here’s a little puzzle to get your mind working It is generally well known that there is a limit to

Continue reading

May 26, 2021 Uncategorized

Why indexes are so fast at finding a key

Glance through any text book, blog post, video tutorial etc on the topic of database indexes and you’ll typically chance

Continue reading

April 13, 2021 Uncategorized

New Podcast Episode! Every index is a bug

Every database has indexes…but should they? In this episode, lets consider a different proposition. What if the indexes you have

Continue reading

April 12, 2021 Uncategorized

Better performance when querying the V$ views

I’m a big fan of giving developers the tools they need to tune their applications in Production if that is

Continue reading

January 27, 2021 Uncategorized

Datatype conversions – strange internal function

Perhaps the most famous (or infamous) performance tuning problem you’ll find spanning decades of blog posts when it comes to

Continue reading

Posts navigation

1 2 3 4 Next Posts»

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

    • Bringing Multimedia back into 19c!
    • How do I stop the use of TRUNCATE
    • Why I blog
    • Let's talk about Techiquette
    • Adding APEX 23.1 to your Database Free VM
    • How to do a GRANT on an entire schema
    • How to TREAT data in a CLOB as JSON
    • Implementing dynamic partitions AND subpartitions
    • How to generate random unique values
    • Is "fragmentation" still a dirty word?
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 863 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...