469,342 Members | 5,948 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,342 developers. It's quick & easy.

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

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

Expand|Select|Wrap|Line Numbers
  1. SELECT
  2.     PDB.PHONENUMBER,
  3.     PD.TEMP_VAR2
  4. FROM
  5.     db_sub_warehouse_b pdb
  6.     JOIN db_sub_warehouse pd ON pdb.subwarehouse_id = pd.subwarehouse_id
  7.     JOIN pd_reportex_b prb ON prb.iccid >= rtrim( pdb.temp_var1 ) 
  8.     AND prb.iccid <= rtrim( pdb.temp_var2 )'
  9. WHERE
  10.     1 = 1 
  11.     AND pd.billcode = 'SW201904160006'
Nov 20 '19 #1
0 2353

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Tristan | last post: by
2 posts views Thread by amos_s12 | last post: by
24 posts views Thread by sureshjayaram | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by haryvincent176 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.