Home » RDBMS Server » Performance Tuning » Regarding cost and Card
Regarding cost and Card [message #65462] Fri, 24 September 2004 20:34 Go to next message
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 Go to previous message
Frank Naude
Messages: 4578
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
Previous Topic: Exec DMBS_STATS Visual Basic
Next Topic: What is Bucket/Chunk and how to check the fragment on shared pool
Goto Forum:
  


Current Time: Wed Feb 28 06:11:15 CST 2024