My Oracle Support Banner

Oracle Demantra Implementing Partitions for Performance (Doc ID 1227173.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Demantra Demand Management - Version 7.0.1 and later
Information in this document applies to any platform.

Goal

Understand what Oracle partitions are and how they can improve Demantra performance.

Are you implementing partitions?  Please see below for a link that provides exact instructions to partition the sales_data table.   Your implementation may require slight modifications.

Demantra How to Create Sales_Data Partition SQL Exact Procedure <Document 1516204.1>


Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
 1. What to do before implementing partitions.
 2. Basic Partitioning.  What is partitioning?
 3. Benefits of partitioning
 4. Partitioning for Availability
 5. Partition Options
 6. Overview of Partitioned Indexes
 7. Partitioning for Performance
 8. Statistics Performed Correctly Improves Partition Performance
 9. Useful SQL
 10. Recommendations
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.