table:bsp, index:date(date) 这个索引走的不对，用SPM临时绑下吧，应该走userid那列索引, 先看下加hint后执行计划对不对，然后再绑
create global binding
for
SELECT bsp.infoid,dfb.pname FROM base.push bsp
LEFT JOIN global.info dfb ON bsp.infoid=dfb.infoid
WHERE userid = 188902 AND dfb.toptype_code = ‘06’ ORDER BY bsp.date DESC LIMIT 5
using
SELECT/+ use_index(bsp, userid)/ bsp.infoid,dfb.pname FROM base.push bsp
LEFT JOIN global.info dfb ON bsp.infoid=dfb.infoid
WHERE userid = 188902 AND dfb.toptype_code = ‘06’ ORDER BY bsp.date DESC LIMIT 5