Re: Tuning the SQL Query

I took a look on your query and don't understood why you used the IN expression.

If you replace this part:

        AND meter.row_id IN
        (
                SELECT /*+ INDEX(meter2 S_ASSET_EM_UNIVID) INDEX(arsm2
S_ASSET_REL_F1) */
                meter2.row_id
                FROM siebel.s_asset_rel_at_MUDR2SEBL arsm2,
                siebel.s_asset_at_MUDR2SEBL meter2
                WHERE arsm2.x_rel_status = 'Active'
                AND arsm2.relation_type_cd = 'SDP-METER'
                AND meter2.row_id = arsm2.asset_id
                AND meter2.data_src = 'JEA'
                AND meter2.type_cd = 'Meter'
                AND meter2.x_universal_id LIKE TRANSLATE(


'25343590','*', '%' )

                AND rownum <= ROUND( 50 * 1.5 )
        )

by this one, your query may improve the performance.

               ( meter.data_src = 'JEA'
                AND meter.type_cd = 'Meter'
                AND meter.x_universal_id LIKE TRANSLATE(


'25343590','*', '%' ) 

                    ) 

Regards,

Carla Received on Mon May 29 2006 - 14:13:28 CDT