Hello,
while trying to get the mat views a few questions arose:
a. sync type leads to a refresh of the _entire_ view, correct?
b. i have to specify all columns that application will be updating in the log ( in case of async (refresh fast) ), correct?
c. can i mix detail tables with ROWID and PK in the same query (that creates a mat view) ?
if "b" is correct, then what columns do i have to specify to insure that deletes on detail tables will refresh the mat view correctly?
If the mat view doesn't update (after rows are deleted from detail table) - how do i troubleshoot?
thank you for your help.
AZ