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

[PaSan]

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

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'

[Chandler]

without database object information, the suggestions by PawSQL are:

CREATE INDEX PAW_IDX1360881332 ON db_sub_warehouse(billcode,subwarehouse_id,TEMP_VAR 2);
CREATE INDEX PAW_IDX1921682121 ON db_sub_warehouse_b(subwarehouse_id,temp_var1,temp_ var2,PHONENUMBER);

you may get more accurate suggestions by supplying more information to the tool.