RE: Merge join cartesian

Hi.

Do you know that your message is spaming my server.... Every few minutes I am receiving your e-mail

Can you please look into this problem and correct it.

Thanks in advance

Francis

		-----Original Message-----
		From:	root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf
Of Siva_Chintalapati
		Sent:	Wednesday, August 02, 2000 4:08 AM
		To:	Multiple recipients of list ORACLE-L
		Subject:	RE: Merge join cartesian

		Hi,
		How toanalize in this way.How will we get the output as


		> Statistics

		> ----------------------------------------------------------

		>          17  recursive calls

		>         238  db block gets

		>      180267  consistent gets

		>       69442  physical reads

		>           0  redo size

		>       32982  bytes sent via SQL*Net to client

		>        1413  bytes received via SQL*Net from client

		>          30  SQL*Net roundtrips to/from client

		>           2  sorts (memory)

		>           1  sorts (disk)

		>         298  rows processed

		.
			Can U pl give me the syntax.

		Regards
		Siva



		> ----------

		> From: 	ARUN K C[SMTP:arun_k_c_at_hotmail.com]

		> Reply To: 	ORACLE-L_at_fatcity.com

		> Sent: 	Wednesday, August 02, 2000 4:15 AM

		> To: 	Multiple recipients of list ORACLE-L

		> Subject: 	Merge join cartesian

		> 

		> Hello all,

		> I have a particular query down below which is doing a

Merge join Cartesian


		> 

		> on one of the tables below

		> Can somebody please let me know how to solve this issue

		> The Table Bl_trans has 10 million rows and the bl_order

has 3 million rows


		> 

		> and the bl_billing_date has only one row

		> select /*+ / substr(bl.fulfilling_florist,1,8) ,

		>        substr(bl.sending_florist,1,8) ,

		>        substr(to_char(bl.delivery_date,'mmddyy'),1,6) ,

		>        substr(upper(bl.to_last_name),1,3) ,

		>        'ordr' ,

		>        to_char(bl.order_value *100,'000000000') ,

		>        to_char(bl.h_order_number,'0000000')  ,

		>        lpad(substr(bl.internal_po,1,10),10,0) ,

		>        to_char(bl.inwire_seq_no,'00000') ,

		>        '00000000' ,

		>        bl.h_sequence_no

		> from flowers.bl_order bl,

		>      bl_billing_dates dt

		>     where bl.h_order_number=bt.h_order_number

		> and  MESSAGE_TYPE=6 AND bl.delivery_date

		> 				between dt.from_date and

dt.to_date


		> 				and bl.message_type = 0

		> 				and bl.wire_service = 'AFS'

		> Down below is the Explain plan

		> Execution Plan

		> ----------------------------------------------------------