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.

Refer to the corresponding information in Note 1013912.32. Can I manipulate statistics to trigger a preferable access path?

April 26, 2017manipulate note preferable refer statistics Trigger

0

Posted

Refer to the corresponding information in Note 1013912.32. Can I manipulate statistics to trigger a preferable access path?

1 Answer

0

Posted

Yes, as of Oracle 8. 1, you can change statistical data using DBMS_STATS packages. For more information on this topic, see Note 724545. If you change statistics manually, the USER_STATS entry belonging to the statistics is converted from NO to YES. You can therefore use this column value to find out whether statistics were manipulated.33. Can statistics be transported from one system to another? Yes, this is also possible as of Oracle 8. 1 using DBMS_STATS packages. For example, you can do this to simulate production system relationships with a large volume of data on a small test system.34. Can the NUM_ROWS field be filled with decimal figures? In certain cases, Oracle may fill the NUM_ROWS field (which records the number of rows in the object) with decimal figures instead of integers. This behavior is normal and does not present a problem.35. Are statistics lost during an Oracle or R/3 upgrade?