Скачать с ютуб Oracle Optimizer Access Methods в хорошем качестве

Oracle Optimizer Access Methods

The Access Method - or access path - in an Oracle execution plan shows how data will be accessed from each table (or index) in your query. The Optimizer selects the Access from the nine different options available to it. This video describes the nine different Access Methods and explains when the Optimizer will choose each one. At the end of the video, you have an opportunity to play the role of the Optimizer as we work through several sample statements and decide what would be the best Access Method for each statement. TOC What are Oracle Optimizer Access Methods? 0:14 How many Access Methods does the Oracle Optimizer have? 0:30 What is a Full Table Scan? 0:54 What is a Table Access By ROWID? 2:19 What is Index Unique Scan? 3:14 What is an Index Range Scan? 3:40 What is an Index Skip Scan? 4:17 What is a Full Index Scan? 5:10 What is a Fast Full Index Scan? 5:59 What is an Index Join? 6:35 What is a Bitmap Index access? 7:10 How to find the access method in an execution plan? 8:02