Oracle Analytics and AI

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.

Thomas Dodds

Opaque view selects ALL data unfiltered then OBIS does filtering ... DB View/Mat View can be predicate filtered on the database

Probably not noticeable on a small volume - in large databases it's a no-no ... so I always do the DB way regardless of the volume.