INSERT optimisation and Batch processing

Seminar:

SQLAdria Seminar – Opatija 2014

Date:

Tuesday, 9 December, 2014 - 09:00 - 10:30

Speaker:

Gareth Z Jones

INSERT optimisation and Batch processing: This presentation looks at how you can optimise your applications and your database design for INSERT-intensive workloads, and for other batch operations/

08 December 2014

Opening -

Triggers, Instead of Triggers and Multi-row operations - Gareth Z Jones

Break -

Archive Transparency and TIMESTAMP with TIMEZONE - Gareth Z Jones

Break -

SQL Features including Intersect/Except/Merge, SELECT FROM INSERT and other SQL coding techniques - Gareth Z Jones

Interpreting the Explain tables, using optimiser hints and establishing query stability - Gareth Z Jones

09 December 2014

INSERT optimisation and Batch processing - Gareth Z Jones

Break -

Java error handling for JDBC and SQLJ applications - Gareth Z Jones

Break -

Dynamic SQL best practices, and analysing query performance - Gareth Z Jones

Closing and Open forum -

INSERT optimisation and Batch processing

08 December 2014

09 December 2014

Useful links

Follow us

Events in 2025