The simple way to refresh materialized views

[@HemantKChitale]

Technically, different MViews in a schema would have been built for different purposes (user requirements). So, they are [expected] to be refreshed at different times / intervals. If you need multiple MVs refreshed together, define a Refresh Group.

[@Seth.Chatterley]

How do you define a refresh group?

[@albertogonzalez5114]

Great explanation, thanks so much!

[@DatabaseDude]

Glad it was helpful!

[@ΠροκόπηςΠουλημένος]

How can we improve materialized views based on complex queries such as join and union and make quicker refresh ?

[@DatabaseDude]

Use DBMS_MVIEW.EXPLAIN_MVIEW to see what is missing in your definition and/or mview log to permit fast refresh

[@APOELULTRA79DC]

Hi this helpful, but for some reason it asks me that I need to declare mview_name. Not sure if its because I am running this code in SQL developer and should run it from the command shell

[@DatabaseDude]

Not sure what you mean. Can you elucidate?

[@HemantKChitale]

Aah ! How many times do developers and DBAs use / configure an account with the DBA role when the DBA role isn't required !

[@DatabaseDude]

indeed :-)

[@berndeckenfels]

TLDR, Refresh all mviews refreshes all mviews :)