Hello all,

I have created an MQT as an unconditional select * from a remote table.
When selecting any number of columns (even just one) from the nickname,
DB2 Explain doesn't seem to consider the MQT at all.
The MQT table has been refreshed, runstats run, I have tried with and
without indexes on the MQT - what am I missing?
(DB2 8.1 FP6, AIX 5.1)


Lars

DB2 & UDB email list listserv db2-l LazyDBA home page