Unanswered: Prevent automatic MQT refresh, if column val didn't actually change
We have an MQT for a query joining a 100-rows table and a 10Million-rows table.
3rd-party software often issues update statements for the the 100-rows table, but it actually doesn't change data. However, a single row update causes partial refresh of the MQT. Is there a way to prevent the refresh, if the new and old column values are equal?