|2nd – 3rd Jun 2016||The Netherlands: I’ll be presenting two topics at the AMIS 25 conference, a masterclass (90 minutes – split into two consecutive sessions of 45 minutes) on “Understanding and Manipulating Parallel Execution Plans”, and a more traditional session called “Just Don’t Do It” – a collection of real (though camouflaged) cases of reducing the workload by constructing (uncommon or even non-standard) SQL that tries to avoid the work that doesn’t need to be done.|
|22nd Jun 2016||Glasgow, Scotland: The annual OUG Scotland conference is due to be held at the Radisson Blu hotel in Glasgow. I’ll be giving my “Just Don’t Do It” presentation and chairing a panel on “Optimisation” (which won’t just be limited to the Cost Based Optimizer).
On the panel we will have: Carl Dudley (12c New features), Joze Senegacnik (Efficient SQL), Kai Yu (ASM CFS for Cloud) and Heli Helskyaho (SQL Developer), so there’s plenty of scope for asking questions which AREN’T just about the optimizer.
|Early July 2016||Birmingham, UK: (Provisional) I’m planning to do an evening session for Oracle Midlands. Topic to be decided.|
|18th – 22nd Sept 2016||San Franciso, USA: . I’ve submitted an abstract for OpenWorld 2016 – and I’ll probably be attending even if it’s not accepted. The abstract title is: “Indexing and the impact on New Technologies”, the abstract is as follows:
Over the last 8 years there have been many dramatic changes to the technology underpinning the Oracle RDBMS. We have Exadata systems, in-memory columnar storage, container databases, and the move to Cloud computing.
Despite these advances we still aim to make the most cost-effective use of the technologies we’ve chosen, and for critical systems that still means selecting the best indexing strategies – even if, in some cases, the best indexing strategy turns out to be “don’t bother”.
In this session we examine how different technologies affect how we index to minimise the workload and maximise the benefit of the technology. The fundamental questions hardly change but an examination of the unique selling points of each feature shows us variations in the cost/benefit analysis that can make a big difference to our choices.
The session will start with a 15 minute introduction to the topic, followed by 30 minutes of Q&A
|28th – 29th Sept 2016||Zurich, Switzerland: . I will be speaking at Trivadis’ annual event, this year called “Database Development and Performance Days” and consisting of two streams. My topics will be: “Just Don’t Do It” – examples of optimising your code by avoiding the work you didn’t need to do, and “Indexing” – a discussion of the benefits we hope to get from indexes (B-tree and Bitmap), why we don’t always get then, and what it costs to try.|
|5th – 7th Dec 2016||Birmingham, UK: I’ve submitted four proposals for UKOUG Tech 16.
I’ll also be around for “Super Sunday” on 4th Dec – but I haven’t submitted a specific abstract for that.