SQL condition optimization:How to optimize statements with greater than condition in

PaSan

How to optimize statements with greater than condition in MySQL.Example:

Expand|Select|Wrap|Line Numbers

 SELECT

    PDB.PHONENUMBER,

    PD.TEMP_VAR2

FROM

    db_sub_warehouse_b pdb

    JOIN db_sub_warehouse pd ON pdb.subwarehouse_id = pd.subwarehouse_id

    JOIN pd_reportex_b prb ON prb.iccid >= rtrim( pdb.temp_var1 ) 

    AND prb.iccid <= rtrim( pdb.temp_var2 )'

WHERE

    1 = 1 

    AND pd.billcode = 'SW201904160006'

SQL condition optimization:How to optimize statements with greater than condition in

Post your reply

Similar topics

Question stats

	Ask Question
Home Questions Articles Browse Topics Latest Top Members FAQ