Sometimes, it is beneficial to lock down your statistics, even if the data changes. The DBMS_STATS package includes procedures to lock table and index stats. Thorough testing of statistics with your application code can determine if locking stats is beneficial to you. The point is that when you lock your stats, you cannot recalculate them.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.