61

Closing and Open forum

Date: 
Tuesday, 9 December, 2014 - 14:15

Dynamic SQL best practices, and analysing query performance

Date: 
Tuesday, 9 December, 2014 - 12:45 - 14:15
Speaker: 
Gareth Z Jones

Dynamic SQL best practices, and analysing query performance  This presentation looks at some dynamic SQL best practices, and also looks at how you can code for and analyse query performance. 

Break

Date: 
Tuesday, 9 December, 2014 - 12:30 - 12:45

Java error handling for JDBC and SQLJ applications

Date: 
Tuesday, 9 December, 2014 - 11:00 - 12:30
Speaker: 
Gareth Z Jones

Java error handling for JDBC and SQLJ applications: This presentation provides some guidance on handling SQL errors and SQL warnings in your Java applications, in the case of JDBC and SQLJ 

Break

Date: 
Tuesday, 9 December, 2014 - 10:30 - 11:00

INSERT optimisation and Batch processing

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/ 

Interpreting the Explain tables, using optimiser hints and establishing query stability

Date: 
Monday, 8 December, 2014 - 16:00 - 17:00
Speaker: 
Gareth Z Jones

Interpreting the Explain tables, using optimiser hints and establishing query stability: There presentation delves into the information available in the EXPLAIN tables which can be used to understand what access path is chosen by DB2 and why. It also looks at how this same infrastructure can be used to provide hints to the optimiser to influence access path selection, and ultimately to ensure that preferred access paths are used for critical queries. 

SQL Features including Intersect/Except/Merge, SELECT FROM INSERT and other SQL coding techniques

Date: 
Monday, 8 December, 2014 - 14:30 - 16:00
Speaker: 
Gareth Z Jones

SQL Features including Intersect/Except/Merge, SELECT FROM INSERT and other SQL coding techniques: This presentation looks at a variety of SQL features introduced over several DB2 releases, and how they can be used to provide improved functionality, performance, and to provide alternative coding techniques for your applications.

Break

Date: 
Monday, 8 December, 2014 - 13:15 - 14:30

Archive Transparency and TIMESTAMP with TIMEZONE

Date: 
Monday, 8 December, 2014 - 11:45 - 13:15
Speaker: 
Gareth Z Jones

Archive Transparency and TIMESTAMP with TIMEZONE:This presentations explores the DB2 11 feature which allows applications to transparently access data in an archive table, and optionally to move non-active data into an archive table. It also looks at the use of time zone information with TIMESTAMP columns. 

Syndicate content  

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023