Blog: Richard Foote

210 blogs updated: 69 min. ago
Index Column Order – Impact On Index Branch Blocks Part I (Day-In Day-Out)
I recently replied on Twitter to some comments regarding an excellent blog post by Franck Pachot Covering indexes in Oracle, and branch size...
04-06-2018 14:42:15 Richard Foote Oracle
Announcing July/August Australian Dates: "Oracle Indexing Internals and Best Practices" Seminar
I'm very excited to announce new Australian dates for my highly acclaimed "Oracle Indexing Internals and Best Practices" seminar. This is a ...
21-05-2018 10:49:54 Richard Foote Oracle
18c Scalable Sequences Part III (Too Much Rope)
I previously looked in Part I and Part II how Scalable Sequences officially released in 18c can reduce index contention issues, by automatic...
08-05-2018 09:47:54 Richard Foote Oracle
ODTUG Kscope18 Conference: Change of Presentation Times
For those of you that were planning to attend my presentations at the upcoming ODTUG Kscope18 Conference in Orlando (yes, I'm specifically t...
03-05-2018 05:36:09 Richard Foote Oracle
18c Scalable Sequences Part II (Watch That Man)
In Scalable Sequences Part I, I introduced this new 18c feature (although it was hidden and undocumented in previous releases). By adding a ...
02-05-2018 10:56:29 Richard Foote Oracle
"Let's Talk Database" is Back !! Canberra/Sydney/Melbourne
Due to popular demand, I've been asked by Oracle to again run some "Let's Talk Database" events this month. Dates and venues are as follows:...
01-05-2018 04:05:59 Richard Foote Oracle
18c Scalable Sequences Part I (Saviour Machine)
One of the problems with populating the value of a Primary Key (or some such), is that they can cause contention, especially in relation to ...
30-04-2018 09:05:24 Richard Foote Oracle
Europe June 2018 Seminars: Confirmed Venues for Oslo, Munich and Zürich
I'm very excited to confirm all venues for the European June 2018 dates of my popular "Oracle Indexing Internals and Best Practices" seminar...
26-04-2018 09:03:15 Richard Foote Oracle
Answer: Anything Wrong With Query Performance? (Red Right Hand)
I of course attract a highly clever readership :). As some have commented, for a single table to require 1000+ consistent gets to retrieve 1...
11-04-2018 10:35:30 Richard Foote Oracle
Question: Anything Wrong With Query Performance? (Straight To You)
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...
05-04-2018 08:30:17 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.