这种SQL如何优化？

wysfenghuo007 · 发表于 2011-4-27 16:31

这种SQL如何优化？

wysfenghuo007 · 发表于 2011-4-27 16:33

这个sql等待太严重了。

tiantianchifan · 发表于 2011-4-27 16:37

大哥，转一下jpg吧~ ol_w_id建立索引，没别的办法

carcase · 发表于 2011-4-27 16:38

i_c_order_time_l1 是 ol_w_id 的单列索引？

tiantianchifan · 发表于 2011-4-27 16:42

67m 5414359行每行不到13bytes，有可能已经是单列索引了

wysfenghuo007 · 发表于 2011-4-27 17:23

只创建了一个索引，
语句如下：
CREATE INDEX tpcc.C_ORDER_LINE_ID ON C_ORDER_LINE( ol_d_ID,ol_o_id)
LOCAL
(
partition ORDER_LINE_ID1 tablespace "ORDER_LINE_tb1",
partition ORDER_LINE_ID2 tablespace "ORDER_LINE_tb2",
partition ORDER_LINE_ID3 tablespace "ORDER_LINE_tb3",
partition ORDER_LINE_ID4 tablespace "ORDER_LINE_tb4",
partition ORDER_LINE_ID5 tablespace "ORDER_LINE_tb5",
partition ORDER_LINE_ID6 tablespace "ORDER_LINE_tb6",
partition ORDER_LINE_ID7 tablespace "ORDER_LINE_tb7",
partition ORDER_LINE_ID8 tablespace "ORDER_LINE_tb8",
partition ORDER_LINE_ID9 tablespace "ORDER_LINE_tb9",
partition ORDER_LINE_ID10 tablespace "ORDER_LINE_tb10",
partition ORDER_LINE_ID11 tablespace "ORDER_LINE_tb11",
partition ORDER_LINE_ID12 tablespace "ORDER_LINE_tb12",
partition ORDER_LINE_ID13 tablespace "ORDER_LINE_tb13",
partition ORDER_LINE_ID14 tablespace "ORDER_LINE_tb14",
partition ORDER_LINE_ID15 tablespace "ORDER_LINE_tb15",
partition ORDER_LINE_ID16 tablespace "ORDER_LINE_tb16",
partition ORDER_LINE_ID17 tablespace "ORDER_LINE_tb17",
partition ORDER_LINE_ID18 tablespace "ORDER_LINE_tb18",
partition ORDER_LINE_ID19 tablespace "ORDER_LINE_tb19",
partition ORDER_LINE_ID20 tablespace "ORDER_LINE_tb20"
);