You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
能否支持force index语法,如果能支持,应该使用哪个方法?
sql example:
SELECT id, user_id, err_code, err_info, create_time, update_time FROM pr_user_record_tabFORCE INDEX(idx_err_id) WHERE (err_code=0 AND id>=12345678) ORDER BY id ASC LIMIT 1000;
The text was updated successfully, but these errors were encountered:
能否支持force index语法,如果能支持,应该使用哪个方法?
sql example:
SELECT
id
,user_id
,err_code
,err_info
,create_time
,update_time
FROMpr_user_record_tab
FORCE INDEX(idx_err_id) WHERE (err_code=0 AND id>=12345678) ORDER BYid
ASC LIMIT 1000;The text was updated successfully, but these errors were encountered: