【产品名称】oceanbase
【产品版本】3.1.1
【问题描述】
想要开启弱一致性读,有多个select需要添加多个hint吗?比如下面的sql语句需要在哪个地方加 /*+read_consistency(weak)*/ *
SELECT count(*) AS low_stock FROM ( SELECT s_w_id, s_i_id, s_quantity FROM Stock WHERE s_w_id in (3,4) AND s_quantity < 20 AND s_i_id IN ( SELECT ol_i_id FROM District JOIN Order_line ON ol_w_id = d_w_id AND ol_d_id = d_id AND ol_o_id >= d_next_o_id - 20 AND ol_o_id < d_next_o_id WHERE d_w_id = s_w_id AND d_id = 2 ))