indexes – Learning is not a spectator sport

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

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

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

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

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

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

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

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

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

If you are loading a data warehouse or similar environment where your default approach would probably be to compress all