What does this mean in EM tuning adviser? Gather statistics Missing "IN or OUT parameter at index:: 2"
No Comments Posted for this Article.
SAP Oracle Missing Indexes
Identify the missing indexes in DB02 (which will reduce the performance without proper indexes) Goto DB02 > Diagnostics > Missing Tables and Index Check the objects that are missing ...
Database Statistics Interview Questions and Answer
Database statistics FAQ1. What are database statistics used for?The Cost Based Optimizer (CBO) requires database statistics in order to use the most suitable access path (for example, index access...