Will Partitioning the HHTFOLOG Table Improve Performance?
(Doc ID 1262166.1)
Last updated on MARCH 23, 2019
Applies to:Oracle Utilities Mobile Workforce Management - Version 22.214.171.124 to 1.4.5 [Release 1.4]
Information in this document applies to any platform.
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?
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