It reads the SQL statements executed from the event monitor tables and runs the Explain utility for each statement to generate the corresponding access plan.
它将读取从事件监控器表执行的sql语句,然后对每个语句运行Explain实用程序以生成对应的访问计划。
To check whether the query does indeed get routed to the MQT, you can get the query Execution plan chosen by the optimizer using the SQL Explain utility and look for MQT access in the plan.
为了检查查询是否确实被路由到MQT,您可以使用SQL Explain实用程序获得由优化器选择的Query Execution Plan,并在计划中查找MQT访问。
应用推荐