Indeed. Just these days the lack of materialized view has been giving me troubles. It would make a certain process about 50 times faster without touching code a

Indeed. Just these days the lack of materialized view has been giving me troubles. It would make a certain process about 50 times faster without touching code at all, and it would take me all of three queries. Granted, the real problem is a poor design of the system, but materialized views would enable me to improve what others have left behind.