Blog: Richard Foote

209 blogs updated: 2 min. ago
Goodbye Oracle (Modern Love)
It's with a mixture of excitement, trepidation and a touch of sorrow that I today handed in my resignation after 6 years at Oracle Corporati...
14-08-2017 09:50:45 Richard Foote Oracle
Basic Index Compression Made Simple (It Ain't Easy)
I've discussed Index Compression a number of times as it's an excellent way of minimizing the size of indexes without unnecessary, expensive...
02-08-2017 04:28:36 Richard Foote Oracle
12.2 Introduction to Real-Time Materialized Views (The View)
Although I usually focus on index related topics, I've always kinda considered Materialized Views (MVs) as an index like structure, which Or...
10-07-2017 10:01:28 Richard Foote Oracle
12.2 Index Deferred Invalidation (Atomica)
One of the useful little features quietly introduced with Oracle Database 12c Release 2 is the ability to now defer the invalidation of depe...
30-05-2017 03:58:20 Richard Foote Oracle
12.2 Some Cool Partitioning New Features (Big Wheels)
I previously discussed just how easy it is to convert online a non-partitioned table to be partitioned with Oracle Database 12.2. Thought I ...
05-04-2017 10:54:23 Richard Foote Oracle
Big Announcement – New Job, New Country (A New Career In A New Town)
After 5 1/2 years at Oracle Corporation, I've decided to leave and take on a very exciting new challenge !! President Trump's office have ac...
31-03-2017 16:34:45 Richard Foote Oracle
12.2 Online Conversion of a Non-Partitioned Table to a Partitioned Table (A Small Plot Of Land)
In my previous post, I discussed how you can now move heap tables online with Oracle Database 12.2 and how this can be very beneficial in he...
27-03-2017 03:02:44 Richard Foote Oracle
Let's Talk Database: New Dates Released (You Can't Talk)
Good news for all you Oracle Database folk in ANZ. I'll be running a new series of "Let's Talk Database" sessions at a venue near you in the...
16-03-2017 07:35:43 Richard Foote Oracle
12.2 Moving Tables Online (Real Cool World)
One of the really cool new features introduced in Oracle Database 12c Release 2 is the capability to MOVE tables ONLINE, while maintaining a...
15-03-2017 08:53:36 Richard Foote Oracle
12.2 Index Advanced Compression "High" Part IV (The Width of a Circle)
A quick post (for me) with a long weekend beckoning In Part I, Part II and Part III of looking at the new Index Advanced Compression level o...
10-03-2017 06:45:46 Richard Foote Oracle

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.