| Regarding cost and Card [message #65462] |
Fri, 24 September 2004 20:34  |
raghukalyan
Messages: 44
Registered: May 2004
|
Member |
|
|
hi ,
I need some info regarding the execution plan.I would like to knw abt the cost ,card and bytes in the execution plan..Wht does cost 94 represent ,card 12 represent in the below example
SELECT STATEMENT Optimizer=CHOOSE (Cost=94 Card=12 Bytes=2532)
Hoping a reply from u guys
Regs
GRK
|
|
|
|
| Re: Regarding cost and Card [message #65466 is a reply to message #65462] |
Mon, 27 September 2004 01:50  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
COST: Estimate of the cost of executing the statement. This value does not have any unit of measurement, and is merely a weighted value used to compare execution plans.
CARDINALITY: Estimate of the number of rows the statement will return.
BYTES: Estimate the number of bytes the statement will return.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
