The reason i am asking is because I have a table with 4 million rows. I need to do a sum on one of the columns based on a condition and it takes a lot of time. If I use materialized view then its fast enough.

I was just wondering whether to use it or not as it is a OLTP system .

Please advice.

Thanks