The following guideline was created to influence the optimizer to consider I11 index, and substantially improved the time to refresh the MQT mqt1 by more than 2X.
但是,可以通过创建下面的指南来影响优化器,使之考虑 I11 索引,从而将 MQT mqt1 的刷新速度提高两倍以上。
步骤1:创建MQT。
Step 1: You could define an MQT as follows
步骤 1:您可以像下面这样定义一个 MQT
应用推荐