R12: Recommendation On Histograms On Columns VENDOR_ID, INVOICE_NUM , ORG_ID , EARLIEST_SETTLEMENT_DATE , INVOICE_DATE Of Table AP_INVOICES_ALL
(Doc ID 2695336.1)
Last updated on JULY 28, 2020
Oracle Payables - Version 12.1.3 and later Information in this document applies to any platform.
While working on optimizing a query based on table AP_INVOICES_ALL, customer noticed that capturing histograms on certain columns of the table, gives an optimized plan for SQL. By default, only three columns are present in FND_HISTOGRAM_COLS for histogram collection. Since creating histogram for few more columns helping to improve performance of the query:
Is there any recommendation from the product team on what all columns of table AP_INVOICES_ALL we should collect histograms?
Are there any know issues If we collect histogram on the following columns of table AP_INVOICES_ALL? EARLIEST_SETTLEMENT_DATE INVOICE_DATE INVOICE_NUM ORG_ID VENDOR_ID
How to purge entries from FND_HISTOGRAM_COLS in case it is needed to rollback the new columns histogram collections?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!