Re: Non-atomic mview refresh and unique index.

From: Yakov Vasilchenko <dexatro_at_gmail.com>
Date: Tue, 22 Oct 2013 15:19:40 +0300
Message-ID: <CAMEMMa2YaEBW+gGqfapJ2pVBxavMDuMXC1QoXAWs2mOHJf0NOg_at_mail.gmail.com>

Hi Mohamed,
This is the very valid points.

However what bugs me is the fact that unusable index seems valid to optimizer to do left-join elimination.
And I cannot find it to be written somewhere that non-atomic refresh makes no promises in case of errors during refresh.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 22 2013 - 14:19:40 CEST

This message: [ Message body ]
Next message: Peter Hitchman: "Re: ORA-00018 but where are the connections coming from?"
Previous message: Mohamed Houri: "Re: Non-atomic mview refresh and unique index."
In reply to: Mohamed Houri: "Re: Non-atomic mview refresh and unique index."
Next in thread: Mohamed Houri: "Re: Non-atomic mview refresh and unique index."
Reply: Mohamed Houri: "Re: Non-atomic mview refresh and unique index."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message