This presentation will go through a real life implementation for Hybrid Columnar Compression (HCC) on a datawarehouse tables. It will go over all the HCC options available on Exadata and how to decide which option to pick. We will also go over impact of sorting on HCC ratio.
We will cover the following topics:
- Options for Exadata HCC
- Using Compression Advisor
- Real life compression ratio
- Ways to move existing tables/partitions/
subpartitions to HCC - Query Performance after using HCC
- Effect of sorting on HCC ratio
- Summary
Diwakar Kasibhotla Biography:
Diwakar Kasibhotla works on Data warehouse implementations performing role of a Data Architect, Data Modeler, Performance Tuning, ETL/BI for last 15 yrs. Diwakar is currently working as a Sr.Data Architect with OppenheimerFunds Inc in a role as lead Architect for Exadata migrations.
--------------------------
Topic: A real life implementation for Hybrid Columnar Compression (HCC)
Date: Wednesday, May 4, 2011
Time: 9:00 am, Pacific Daylight Time (San Francisco, GMT-07:00)
Meeting Number: 596 688 680
Meeting Password: 123456
------------------------------
To join the online meeting (Now from mobile devices!)
------------------------------
1. Go to https://oracleconferencing.
2. If requested, enter your name and email address.
3. If a password is required, enter the meeting password: 123456
4. Click "Join".
To view in other time zones or languages, please click the link:
https://oracleconferencing.
------------------------------
To join the teleconference only
------------------------------
Call-in number: 1-866-682-4770
Conference Code: 6076676
Password: 123456
------------------------------
For assistance
------------------------------
1. Go to https://oracleconferencing.
2. On the left navigation bar, click "Support".
You can contact me at:
philip.stephenson@oracle.com
1-650-607-0663
To update this meeting to your calendar program (for example Microsoft Outlook), click this link:
https://oracleconferencing.
WebEx will automatically setup Meeting Manager for Windows the first time you join a meeting. To save time, you can setup prior to the meeting by clicking this link:
https://oracleconferencing.
