对于所有支持HINT的语句,允许在语句前指定HINT,例如:
/*+TDDL: ... */ SELECT ...
/*+TDDL: ... */ INSERT ...
/*+TDDL: ... */ REPLACE ...
/*+TDDL: ... */ UPDATE ...
/*+TDDL: ... */ DELETE ...
/*+TDDL: ... */ CREATE TABLE ...
/*+TDDL: ... */ ALTER TABLE ...
/*+TDDL: ... */ DROP TABLE ...
/*+TDDL: ... */ SHOW ...
设置SQL超时时间为40秒:
/*+TDDL:SOCKET_TIMEOUT(40000)*/SELECT * FROM t_item;
指定SQL在某个分库上执行:
/*+TDDL:node('node_name')*/
FORCE INDEX():语法与MySQL FORCE INDEX相同,若指定的索引不是GSI,则会将FORCE INDEX下发到MySQL上执行。
# FORCE INDEX()
tbl_name [[AS] alias] [index_hint]
index_hint:
FORCE INDEX({index_name}) &n