How to Bring Your Data Warehouse to the Next Level of Performance

28 Jan 2019
17:00 - 17:45

How to Bring Your Data Warehouse to the Next Level of Performance

We will discuss several techniques to improve Dw running on Oracle 12c:
MVs, including query rewrite
Partitions
IMDB
Parallel queries

We will see the pro and cons of each option,what gains are possible,how to use them,how to avoid pitfalls, possible use cases,etc