Meanings of parameters in the Oracle execution plan

Card refers to the number of rows processed in this step in the plan; cost refers to the resources consumed by this step in cbo, and this value is relative value; bytes indicates the number of bytes of all records processed in the cbo step.

Card refers to the number of rows processed in this step in the plan; cost refers to the resources consumed by this step in cbo, and this value is relative value; bytes indicates the number of bytes of all records processed in the cbo step.

Homepage → Database Technology

Background:

Read News

Meanings of parameters in the Oracle execution plan

[Date:] Source: Linux community Author: nsj820 [Font:]

Card refers to the number of rows processed in this step in the plan; cost refers to the resources consumed by this step in cbo, and this value is relative value; bytes refers to the number of bytes of all records processed in this step in cbo. It is an estimated set of values.

· Cost: The cost assigned to each step of the query plan by the CBO. the CBO worksby generating implements different execution paths/plans for the same query andassigns a cost to each and every one. the query plan with the lowest cost wins.

· Card: Card is shortCardinality. It is the estimated number of rows that will flow outof a given query plan step.

· Bytes: The size in bytes of the data the CBO expects each step of the plan toreturn. This is dependent on the number of rows (Card) and the estimated widthof the rows.

0

RedHat bare device startup configuration for RAC

Installation notes for Oracle 11g on SUSE Enterprise 10 Linux

Oracle tutorial

Image Information

View All comments in this article (0)

Comments

Latest Information

Popular this week

Introduction to Linux community-advertisement service-website map-help Info-contact us
The articles published on this site (LinuxIDC) do not mean that they agree with the statement or description. They only provide more information and do not constitute any suggestions.


Copyright©2006-2011 Linux community All rights reserved Zhejiang ICP backup No. 06018118

,