开发者

What does operation column in plan table do?

What does operation column 开发者_如何转开发in plan table do?? I am working on Oracle 10g and I would like to know about the significance of values in that particular column!


From the same Oracle 10G Performance Tuning Guide I linked to in a previous question:

Name of the internal operation performed in this step. In the first row generated for a statement, the column contains one of the following values:

  • DELETE STATEMENT
  • INSERT STATEMENT
  • SELECT STATEMENT
  • UPDATE STATEMENT

See Table 19-3 for more information on values for this column.

I found this by looking in the index under "O" for "Operation".


The operation column tells you what kind of operation is being performed here. It can take values like INSERT STATEMENT, HASH JOIN, TABLE ACCESS, or SORT.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜