Hi
I want to find the cost of query i use.
I hope explain Plan is the command .


db2 => explain plan for select cs.model,cs.vemail,cs.made
cs_made,cs.updat,cs.subscrib, \
db2 (cont.) =>
cs.spcl1,cs.spcl2,cs.spcl3,cs.spcl4,cs.spcl5,cs.spcl6,cs.spcl7,cs.spcl8, \
db2 (cont.) => ct.to_page, ct.made ct_made,ct.campaign \
db2 (cont.) => from cust_spec cs, click_thru ct \
db2 (cont.) => where cs.vemail=ct.vemail
DB20000I The SQL command completed successfully.


How to find the cost of the above query.



With regards
saiprasad

DB2 & UDB email list listserv db2-l LazyDBA home page