Thanks Mkeintz for your reply. the purpose is to do a Cartesian join,. We have offers for customers and we would like to see what other offers the same customer has , which we call overlap offers. Your suggestion 1 with including where clause along with the table name is definitely efficient. I will implement that. from gmog.loaded_detail_&livedate (where=(subchannel=&subchannel)) a , gmog.loaded_detail_&livedate (where=(subchannel=&subchannel)) b where a.pty_id=b.pty_id group by 1,2,3 ... Coming to from gmog.loaded_detail_&livedate (where=(subchannel in (chn1,chn2,...chn141))) a , gmog.loaded_detail_&livedate (where=(subchannel in (chn1,chn2,...chn141))) b where a.pty_id=b.pty_id and a.subchannel=b.subchannel group by subchannel,1,2,3,.. the dataset has all the 41 channels and the doing a join by pty_id and subchannel wasn't working because the data is huge. I tried that and had no luck. so had to do it by each individual channel. thanks for the inputs.
... View more