![]() SQL management base (SQL plan baselines).Data operations, such as filter, sort, or aggregationĮxecution plan is a vital point for Performance tuning of Oracle database, then Where to access or Find Execution Plans?.An ordering of the tables referenced by the SQL statement.You can see the following information in the Execution plan steps. You should decide which one to use.ĭatabase management system is running like this example.Įxecution plan steps are performed in a parent-child relationship between steps, they are not performed in the order in which they are numbered. You have several ways for going to London, but each of these vehicles’ cost is different. There are several ways for this travel as follows. What is the Oracle Optimizer and How Cost-Based Optimizer Works ? | Oracle Database Performance Tuning Tutorial -3Įxecution plan consists of the instructions for the execution engine about the operations it must perform for retrieving the data most efficiently.įor Example You want to go to B point ( London) from A point ( Istanbul ). ![]() If you want to learn more details about Optimizer, You should read the following article before this. I will explain What is the Execution Plan and How to Generate Execution Plan in this article.Įach Database management system like Oracle generates an execution plan for SQL Statements to present to the execution engine for implementation which is the output of the optimizer.
0 Comments
Leave a Reply. |