Plan_table Columns

From: <eric_peterson_at_maurices.inrg.com>
Date: Thu, 19 Aug 1999 15:42:36 GMT
Message-ID: <7ph8l8$1b7$1@nnrp1.deja.com>

I am running some explain plans and was looking at columns I don't normally use. Does anyone know what the following columns give me?

  POSITION                                NUMBER(38)
  COST                                    NUMBER(38)
  CARDINALITY                             NUMBER(38)
  BYTES                                   NUMBER(38)

I have looked at all four columns on several different statements ranging in different levels of complexity. I believe the COST column is mainly used for the COST BASED OPTIMIZER and I am assuming that a low number is good. What can I expect out of the BYTES field, i.e. what does this represent? I have looked at Oracle Documentation but have not found a good explanation of what these fields represent.

BTW I am on Oracle 7.3.3.6

Eric Peterson
Programmer/Analyst DBA
Maurices Inc.
eric_peterson_at_maurices.inrg.com

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 19 1999 - 10:42:36 CDT