Writing Optimal SQL & Troubleshooting & Tuning with Jonathan Lewis – Zagreb 7-8 May
| May 7, 2012 |
Oracle University Zagreb, Croatia
During this seminar you will firstly learn how do you improve the performance of a production system by attacking inefficient SQL and how do you design a system so that you can get data into and out of it efficiently. Read more »

At first sight table-partitioning seems very simple, but when an actual table needs to be partitioned, a number of alternative strategies may be used, with different consequences on performance, availability, backup and restore. This seminar will discuss and show some of the more difficult aspects of partitioning – hard to locate in the manuals.
Materialized Views are as important to Business Intelligence systems as Indexes are to OLTP systems.