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...
3
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 ...
0
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...
0
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...
10
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 ...
10
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:...
9
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 ...
12
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...
9
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...
10
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...
11
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.