I've created a materialised view in SQL Server, but when selecting from it I get the same performances and the same execution plan than when I select from the same query not "materialised".
The view is simple:
CREATE VIEW TestView WITH SCHEMABINDING
SELECT TAB_A.C1, TAB_A.C2, TAB_A.C3
INNER JOIN TAB2 ON TAB1.C2 = TAB2.C2
INNER JOIN TAB3 ON TAB2.C1 = TAB3.C1;
CREATE UNIQUE CLUSTERED INDEX IX_TestView
ON TestView(C1, C2, C3);
Now, when I do something like
SELECT C1 FROM TestView
I'd expect to see in the plan only an access to the view and nothing else, instead it accesses the underlying tables like the view does not even exists. I get exactly the same plan and the same execution time, too.
What am I doing wrong? If SQL Server cannot "materialise" the view, I'd expect to at least get an error when creating it.