My Oracle Support Banner

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 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

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