Richard Foote's Blog

Subscribe to Richard Foote's Blog feed Richard Foote's Blog
Focusing Specifically On Oracle Indexes, Database Administration and Some Great Music
Updated: 6 days 8 hours ago

Answer: Anything Wrong With Query Performance? (Red Right Hand)

Wed, 04/11/2018 - 08:12
I of course attract a highly clever readership :). As some have commented, for a single table to require 1000+ consistent gets to retrieve 1000 rows implies that each row needs to be accessed from a different block. This in turn implies the Clustering Factor for this index to be relatively bad and the associated […]

Question: Anything Wrong With Query Performance? (Straight To You)

Thu, 04/05/2018 - 05:21
I have a query that runs pretty darn efficiently, here’s the setup: So the query basically returns 1000 rows based on the CODE column and it does so using an index on CODE. The CBO has got the costings for this just about spot on. For 1000 rows returned, it does so with just 1006 […]

BIG NEWS: I’ve Been Selected On “Journey To Mars” Program !!

Sat, 03/31/2018 - 22:56
HAPPY APRIL FOOLS !! After many months of nervous waiting, knowing that my chances were extremely slim at best, I have just received my confirmation letter from NASA saying that I’ve been one of the lucky ones selected to participate in the “Journey To Mars” program !! I’m soooo damn excited !!! Planning is now […]

Richard Foote Consulting Seminars At Your Workplace !!

Wed, 03/28/2018 - 05:04
If you have 6 or more people in you organisation who would be interested in attending a seminar, please contact me at richard@richardfooteconsulting.com. I currently run my highly acclaimed “Oracle Indexing Internals and Best Practices” seminar as public events, which has now been run in some 18 countries. I’m also at work on developing an […]

Announcement: Europe June 2018 Dates – Oracle Indexing Internals Seminar

Wed, 03/21/2018 - 04:47
I’m very excited to announce some European June 2018 dates for my popular “Oracle Indexing Internals and Best Practices” seminar. This is a must attend seminar of benefit to not only DBAs, but also to Developers, Solution Architects and anyone else interested in designing, developing or maintaining high performance Oracle-based applications. It’s a fun, but […]

Presenting At ODTUG Kscope18 Conference in Orlando, Florida 10-14 June 2018

Tue, 03/20/2018 - 03:47
I’m very excited to have a couple of papers accepted at this year’s ODTUG Kscope18 Conference in sunny and likely very hot Orlando, Florida between 10-14 June 2018. I’m excited because I’ve been to a few of these conferences before and they have always been excellent events. As a mainly Oracle Database kinda guy, it’s […]

Improve Data Clustering on Multiple Columns Concurrently (Two Suns in the Sunset)

Mon, 03/12/2018 - 08:30
I’ve had a couple of recent discussions around clustering and how if you attempt to improve the clustering of a table based on a column, you thereby ruin the current clustering that might exist for a different column. The common wisdom being you can only order the data one way and if you change the […]

Trivadis Performance Days 2018

Thu, 03/08/2018 - 01:06
I’m very excited and privileged to be asked to present the opening and closing sessions at this year’s Trivadis Performance Training Days in Zurich, Switzerland on 19-20 September 2018. It’s one of the premier Oracle training events in Europe, one which I’ve always wanted to attend. This year has a fantastic lineup, so I’m really […]

My New David Bowie Blog

Tue, 03/06/2018 - 23:11
Just a short note to say I’ve started a new blog that we focus on the one and only David Bowie: https://davidbowiewordpresscom.wordpress.com/ Those of you that only vaguely know me, know I’m a huge David Bowie fan, so I thought it might be a bit of fun to write about his extraordinary body of work. I’m […]

Oracle Database 18c: Introduction to Memoptimized RowStore (Memory of a Free Festival)

Mon, 03/05/2018 - 05:29
One of the potentially cool new features introduced in Oracle Database 18c is the Memoptimized RowStore, designed to improve the performance and scalability of key-value based queries. A new pool in the SGA called the Memoptimize Pool can be configured to store specific heap tables that you may wish to optimize, in a manner not […]

Oracle Database 18c Indexing Related New Features (New Angels of Promise)

Tue, 02/27/2018 - 04:29
Although the recently released Oracle 18c Database is really just 12.2.0.2 under the covers, there are a few little features and enhancements that are of interest from an indexing perspective. These include: Memory Optimized Rowstore Scalable Sequences Oracle Text indexing enhancements, such as automatic background index maintenance and new optimize index options JSON Search Index […]

European Indexing Internals Seminar Events: Please Help Me Select (Station To Station)

Tue, 02/20/2018 - 01:35
I’m currently determining which European countries to initially target for a series of my 2 day Oracle Indexing Internals and Best Practices seminars tentatively scheduled for the late May / early June time frame. The cost for the 2 day seminar is to be confirmed but will be approximately 1200 Euros (plus any local taxes), […]

Index Skip Scan: Potential Use Case or Maybe Not ? (Shine On You Crazy Diamond)

Tue, 01/30/2018 - 11:57
While answering a recent question on a LinkedIn forum, it got me thinking whether there’s a potential use case for using an INDEX SKIP SCAN I hadn’t previously considered. I’ve discussed Index Skip Scans previously (as I did here), a feature introduced around Oracle9i that allows an index to be considered by the CBO even […]

Announcement: Oracle Indexing Internals Seminars Coming to New Zealand in March 2018 (Shipyards of New Zealand)

Mon, 01/22/2018 - 01:14
I’m very pleased to announce I’ve now finalised some dates in New Zealand for my popular and highly acclaimed “Oracle Indexing Internals and Best Practices” seminar. They are: Wellington 12-13 March 2018: Tickets and Registration Link Auckland 15-16 March 2018: Tickets and Registration Link As usual, numbers will be strictly limited due to the small class nature […]