Hotsos Symposium Speaker – Bruce Ernst

Bruce Ernst is a new Hotsos Symposium presenter.

Biography

Bruce ErnstBruce Ernst has several decades of DBA and application development experience. Bruce also has fourteen years of an experience as an instructor and curriculum developer at Oracle. In addition to teaching for Oracle for three years, he has presented at Oracle OpenWorld and at regional Oracle User Groups.

Presentation Title

Improving Performance Using Bitmap Indexes

Abstract

Because the data-warehousing code from a vendor was causing I/O bottlenecks, we decided to investigate if we could improve performance by switching from the normal indexes used by the vendor to bitmapped indexes.

This presentation is for those considering a change to bitmapped indexes. It compares normal and bitmap indexes, describes the process used to convert to bitmap indexes, and presents statistics from a real-world case and reproducible-test case to show how bitmapped indexes reduced storage and improved query performance.

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

The speaker schedule is as follows: