Recently we are seeing that optimizer is not picking up replicated MQT. Although the stats are more current on MQT that the base table. It still doesn't use it. If I hard code the MQT the access plan looks great and thats what it used to happen before. Any ideas, this is related to Facts and dimensions. All of my imensions are replicated with refresh immediate.