6 Replies Latest reply on Mar 6, 2017 4:36 PM by Robert Angel

    Opaque versus DB View

    Robert Angel

      Hi,

       

       

      For a dimension if there is a choice between a DB view, imported as a physical table source, or an opaque view, is there any difference in performance if the underlying SQL is identical?

       

      I know neither is desirable!

       

      My version is 12.2.1 if it makes any difference.

       

       

      thanks,

       

      Robert.