Collecting the statistics with BRCONNECT Vs DBMS_STATS.
Posted on 2006-06-29
I am using SAP with Oracle database. In order to collect the statistics we use BRCONNECT. But it takes very long time to collect statistics for the big tables with large number of rows.
Can I use the oracle mechanism of DBMS_STATS for collecting statistics in SAP environment?
Is there any way to use BRCONNECT along with DBMS_STATS ?
Please suggest the best performance way to collect the statistics in SAP.
Thanks and regards,
- Raj Kumar Singh