how do i create a materialized view that refreshes every midnight from a table with millions of rows, which has thousands of new data being inserted every. this materialized view is needed for report purposes so as not to strain the main tables with the heavy queries the reports will be generating. i really need this to be done as my boss has a gun in my mouth ready to fire! never with materialized views. thanks.