Images

CHAPTER

9

Big Data, Business Intelligence, and Data Warehousing New Features

Oracle Database has always had features to help you scale your database size for almost any application, whether it be for OLTP or data warehouse applications. The key database feature for scaling both of those application types is table and index partitioning: the less data you have to sift through to get the results you want, the better your response time will be when you run queries or run your nightly ETL. In the first part of this chapter, I’ll cover a few of the new partitioning features in Oracle Database 12c Release 2, including enhancements to list partitioning ...

Get Oracle Database 12c Release 2 New Features now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.