![]() Here’s how you can generate an execution plan in DataGrip.įirst, connect to your database and write or paste in your query. I’ve been using the DataGrip IDE by Jetbrains recently. We’ll take a look at how to view the execution plan in other ways, then see what this example is doing. Cost: a number representing the cost of this step and all steps below it.Cardinality: the number of rows in this step.Options: extra attributes for this step, such as the type of table access.Object Name: the name of the object (table, index) that is used in this step.Operation: the task that is performed, such as Hash Join or Nested Loops.We finish with a “Select Statement” which is the end of the query.Further steps are executed as you move up the hierarchy.The steps in the query are run from the bottom of the hierarchy, or the most-indented row.Each step in the query is shown in a hierarchical layout.We’ll get into the details of the steps later, but here’s what it’s showing: This is what the execution plan looks like in Oracle SQL Developer: Once you do this, a tab appears at the bottom of the window with your execution plan. Once you have those, you simply click on the Explain Plan button on the toolbar, or press F10. A query you want to see the execution plan of.The process is similar in other IDEs, but SQL Developer is one of the most popular, so I’ll explain the steps here. ![]() Generating an execution plan in SQL Developer is quite easy.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |