What is the correct way to find out if a given indexed view had materialized indeed? When I look at the query plan for a SELECT statement from that view, it shows all the tables that the view is based on. Therefore I conclude it is not materialized. However all the conditions described in BOL were met. Is there any other thing that tells if an indexed view is materialized?