Hi,



Please suggest the optimal method to extract the information with
minimal time.



select
x.id||','||x.yl2||','||x.yl3||','||ol1.value||','||ol2.value||','||ol3.v
alue||','||ol4.value

from table1 x,table2 y,table3 ol1,table3 ol2,table3 ol3,table3 ol4

where y.id=x.cust_order_id

and x.id=ol1.com_col

and ol1.com_col=ol2.com_col

and ol2.com_col=ol3.com_col

and ol3.com_col=ol4.com_col

and ol1.name='abc'

and ol2.name='xyz'

and ol3.name='man'

and ol4.name='sss'

and to_date(ol1.value,'dd-mm-yyyy hh24:mi') < to_date('03-09-2007
00:00','dd-mm-yyyy hh24:mi')

and x.execution_status not in ('QQ','WW','ZZ')

order by x.id;





Manish Kumar Sahay



A journey of a thousand miles begins with a single step." Make sure you
are there and on time !!





============================================================================================================================

Disclaimer:

This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.

============================================================================================================================

Oracle LazyDBA home page