A6 operators Banks,
A7 car car number,
A8 box number
A10 hair stand,
A13 arrive station,
A14 to bureau,
A20 shipper,
A21 consignee,
A9 transportation way,
A22 item number,
A36 spreads,
A24 category code,
A23 name,
A30 car number,
A31 box number,
A32 chargeable weight,
A34 combined freight,
A145 fund,
A242 stamp duty,
A147 miscellaneous fees add up, and the
A162 container fee,
The fare from a194 off,
A232 gathering station terminal charges,
A234 station terminal charges,
A235 valuation fee,
A404
The from zz_565_2018
Where bm='container'
And yf & gt;='202010' | | SUBSTR (UID, 1, 0)
And yf & lt;='202010' | | SUBSTR (UID, 1, 0)
And a8 like '% tttt1111111 %'
The order by a4
Execution time need 900 seconds, how to optimize, thank you
CodePudding user response:
Look at the execution plan?Confirm the bm='container'
And yf & gt;='202010' | | SUBSTR (UID, 1, 0)
And yf & lt;='202010' | | SUBSTR (UID, 1, 0)
The filterability of the strongest of these conditions is the field, how much total table records, a separate condition to check how many records? To determine which index should go