On Wed, Apr 10, 2013 at 10:33 PM, Vincent Veyron <vv.li...@wanadoo.fr>wrote:
> I find this rather surprising, considering the fact that a properly > tuned database will return queries over millions of rows and multiple > joins in milliseconds, given the proper hardware. > > I can see how a datawharehouse with terrabytes of data can make use of > them, but that is hardly a common situation. It seems to me many of > these people clamouring for materialized views would be better off > simply using a proprer data structure (and taking a few SQL courses). > > Am I misguided? A use case of materialized views is cache for web application where you could refresh them with complicated join queries running in background. You cannot do that with a view as it would be necessary to reprocess the query each time, and it is difficult to do that with only tables as this could incredibly complicate your database schema. -- Michael
