Informix对index的首个列进行High级别的统计更新。如 索引, create index idx_name (c1,c2,c3) on t1; create index idx_name2(c5) on t2;那么统计更新这样做:update statistics high for table t1(c1);update stati...
显示全部Informix对index的首个列进行High级别的统计更新。
如 索引, create index idx_name (c1,c2,c3) on t1;
create index idx_name2(c5) on t2;
那么统计更新这样做:
update statistics high for table t1(c1);
update statistics high for table t2(c5);
收起