Indexed Views Don't seem equivalent to Oracle Materialized

Question

It has been quite a while since I used SQL Server and mainly worked on Oracle databases. I'm used to building materialized views from my OLTP tables to speed things up. I was happy to find information on what looked like the SQL Server equivalent of a Mat view ... however, when I started reading and testing, I realized that I couldn’t do things like subqueries. creating the view that I was about to index. Are there any other methods in SQL Server that people use to speed up queries and create “reporting layers” from existing OLTP tables? S I could add a lot more indexes, etc. In the base tables, I just wanted to see if I could do something to view the Mat.

I could be completely wrong in indexed views ... still very ignorant, so if I missed something, let me know.

Thank!

-S

Answer 1

Indexed views have many (and I mean LOT) more restrictions than materialized views of Oracle. What you could do to speed up reporting is to create pre-calculated tables and processes that update them. You can also use partitioning to manage ever-growing tables.

Answer 2

OLTP db - , . .