Learn how to leverage Oracle DB Performance Tuning optimizer statistics for max performance! PART-1
Автор: Anish kumar
Загружено: 2023-11-04
Просмотров: 4616
What are Optimizer Statistics? Optimizer statistics are a collection of data that describe the database and the objects in the database. These statistics are used by the optimizer to choose the best execution plan for each SQL statement.
The optimizer cost model relies on statistics collected about the objects involved in a query, and the database and host where the query runs.
The optimizer uses statistics to get an estimate of the number of rows (and number of bytes) retrieved from a table, partition, or index. The optimizer estimates the cost for the access, determines the cost for possible plans, and then picks the execution plan with the lowest cost.
For more Information Visit:
https://asrblogger.com/
#oracledatabase #oracledatabasetutorial #performancetuning #databasetuning #performanceoptimization #asrblogger #asrbloggerdba
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
