Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to view the contents of the implementation plan in the database, which has certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let Xiaobian take you to understand it together.

plsql How to choose to view the contents of the execution plan:

tools >>tools >>Preferences>>plan window >> Select columns to display

operation: operation, the name of each step involved in sql [this is the center of gravity we should focus on]

object name: operation name

object type: type of operation object,exp:table,column,index,view, etc.

rows--cardinality: oracle estimates the number of rows in the return result set for the current operation

bytes--bytes: number of bytes returned after performing this step

cost--CPU cost--CPU cost: Oracle's estimate of the execution cost of this step, used to illustrate the representative of SQL execution, theoretically the smaller the better (this value may differ from the actual, but should also be concerned)

time--time: oracle estimates the time required for the current operation

Thank you for reading this article carefully. I hope that the article "How to View the Content of Implementation Plan in Database" shared by Xiaobian will be helpful to everyone. At the same time, I hope that everyone will support you a lot and pay attention to the industry information channel. More relevant knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.