Will Partitioning the HHTFOLOG Table Improve Performance?

(Doc ID 1262166.1)

Last updated on NOVEMBER 10, 2010

Applies to:

Oracle Utilities Mobile Workforce Management - Version: 1.4.2.4 to 1.4.5 - Release: 1.4 to 1.4
Information in this document applies to any platform.

Goal

Our production HHTFOLOG table is ~3.6 GB and contains 21 million rows. The application is accurately maintaining one year of historical records in this table as dictated by our business requirements. To aid performance, we would like to partition the table. Will this impact the application? On what field should the partition be made?


Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms