Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Are the statistics of DBMS_STATS and ANALYZE compatible?

April 26, 2017analyze compatible dbms_stats statistics

0

Posted

Are the statistics of DBMS_STATS and ANALYZE compatible?

1 Answer

0

Posted

The two types of statistics are not fully compatible, which causes problems when you create DBMS_STATS statistics for objects with ANALYZE statistics and vice versa. For more information, see Note 489352. When changing the method, you should therefore first delete statistics using the function of the method used to date (“ANALYZE TABLE … DELETE STATISTICS” or DBMS_STATS.DELETE_…_STATS) before new statistics are created. Deletion of these old statistics has already been implemented in current versions of BRCONNECT and BW.