727: bis_collection_utilities.put_line(' ');
728: bis_collection_utilities.put_line('Analyzing temp tables');
729: fii_util.start_timer;
730:
731: fnd_stats.gather_table_stats(ownname => g_isc_schema,
732: tabname => 'ISC_DBI_TMP_BSA_ORDER_LINES');
733: fnd_stats.gather_table_stats(ownname => g_isc_schema,
734: tabname => 'ISC_CURR_BSA_ORDER_LINES');
735:
729: fii_util.start_timer;
730:
731: fnd_stats.gather_table_stats(ownname => g_isc_schema,
732: tabname => 'ISC_DBI_TMP_BSA_ORDER_LINES');
733: fnd_stats.gather_table_stats(ownname => g_isc_schema,
734: tabname => 'ISC_CURR_BSA_ORDER_LINES');
735:
736: fii_util.stop_timer;
737: fii_util.print_timer('Analyzed the temp tables in ');
1498: bis_collection_utilities.put_line(' ');
1499: bis_collection_utilities.put_line('Analyzing temp tables');
1500: fii_util.start_timer;
1501:
1502: fnd_stats.gather_table_stats(ownname => g_isc_schema,
1503: tabname => 'ISC_DBI_TMP_BSA_ORDER_LINES');
1504: fnd_stats.gather_table_stats(ownname => g_isc_schema,
1505: tabname => 'ISC_CURR_BSA_ORDER_LINES');
1506:
1500: fii_util.start_timer;
1501:
1502: fnd_stats.gather_table_stats(ownname => g_isc_schema,
1503: tabname => 'ISC_DBI_TMP_BSA_ORDER_LINES');
1504: fnd_stats.gather_table_stats(ownname => g_isc_schema,
1505: tabname => 'ISC_CURR_BSA_ORDER_LINES');
1506:
1507: fii_util.stop_timer;
1508: fii_util.print_timer('Analyzed the temp tables in ');