Materialised View vs physical table
I’m really getting confused as why to use a materialised view instead of a normal table. if it is because of convinience of writing a complex query, precomputing and storing then we can do the same thing with a table by inserting a new data into a table everyday like how we refresh MV. Am I missing something? Could anyone please explain where and why we should use MV instead of a table?