Wednesday, 31 May 2023

How to gather table stats on specific object with percent and degree

 set time on ;

set feedback on ;


 exec fnd_stats.gather_table_stats('QP','QP_PRICING_ATTRIBUTES',PERCENT =>30, DEGREE => 1);

 exec fnd_stats.gather_table_stats('QP','QP_LIST_LINES',PERCENT =>30, DEGREE => 1);

 exec fnd_stats.gather_table_stats('QP','QP_LIST_HEADERS_B',PERCENT =>30, DEGREE => 1);

 exec fnd_stats.gather_table_stats('QP','QP_LIST_HEADERS_TL',PERCENT =>30, DEGREE => 1);

 exec fnd_stats.gather_table_stats('INV','MTL_SYSTEM_ITEMS_B',PERCENT =>30, DEGREE => 1);

 exec fnd_stats.gather_table_stats('INV','MTL_CATEGORIES_B',PERCENT =>30, DEGREE => 1);