Blog: Richard Foote


213 blogs updated: 35 min. ago
AUSOUG "Oracle Master" Award
I was very flattered and honoured to be named one of the first 4 "Oracle Masters" by the Australian Oracle User Group at the recent AUSOUG C...
0
22-11-2018 03:15:59 Richard Foote Oracle
Presenting at AUSOUG Connect 2018 Conference in Melbourne, 21 November 2018.
After initially not being in a position to make it this year, I will now be presenting at the AUSOUG Connect 2018 Conference in Melbourne th...
0
18-11-2018 13:26:21 Richard Foote Oracle
Enable Index To Search For NULLs By Adding Constant to Index List. But Some Constants Better Than Others (Never Let Me Down)
By default, Oracle doesn't index an entry if all columns within the index are NULL. However, (as I've blogged previously), it's possible to ...
4
15-11-2018 02:17:49 Richard Foote Oracle
March 2019 – New Webinar Dates Announced for "Oracle Indexing Internals and Best Practices"
I'm very excited to announce two new Webinar events for my acclaimed "Oracle Indexing Internals and Best Practices" training event, running ...
0
14-11-2018 05:50:11 Richard Foote Oracle
FIRST_ROWS_10 CBO Is Hopeless, It's Using The Wrong Index !! (Weeping Wall)
There's an organisation I had been dealing with on and off over the years who were having all sorts of issues with their Siebel System and w...
0
05-11-2018 13:27:38 Richard Foote Oracle
"Hidden" Efficiencies of Non-Partitioned Indexes on Partitioned Tables Part IV" (Hallo Spaceboy)
In Part I, Part II and Part III we looked at some advantages of Global Indexes that may not be obvious to some. One of the advantages of a L...
0
31-10-2018 04:34:31 Richard Foote Oracle
"Hidden" Efficiencies of Non-Partitioned Indexes on Partitioned Tables Part III" (Ricochet)
In Part I and Part II of this series, we looked at how Global Indexes can effectively perform "Partition Pruning" when the partition keys ar...
0
25-10-2018 04:14:24 Richard Foote Oracle
"Hidden" Efficiencies of Non-Partitioned Indexes on Partitioned Tables Part II (Aladdin Sane)
In Part I of this series, I highlighted how a Non-Partitioned Global Index on a Partitioned Table is able to effectively perform "Partition ...
0
09-10-2018 09:33:16 Richard Foote Oracle
"Hidden" Efficiencies of Non-Partitioned Indexes on Partitioned Tables Part I (The Jean Genie)
When it comes to indexing a partitioned table, many automatically opt for Local Indexes, as it's often assumed they're simply easier to mana...
0
04-10-2018 10:26:13 Richard Foote Oracle
New Zealand: "Oracle Indexing Internals and Best Practices" Seminars November 2018.
Good news for those of you in beautiful New Zealand. Due to popular demand, I'll be returning to run some of my acclaimed "Oracle Indexing I...
0
24-08-2018 01:20:35 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.