Will Partitioning the HHTFOLOG Table Improve Performance? (Doc ID 1262166.1)
Last updated on NOVEMBER 10, 2010
Oracle Utilities Mobile Workforce Management - Version: 184.108.40.206 to 1.4.5 - Release: 1.4 to 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?
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