do views use table indexes?
Yes, the underlying table indexes are used automatically - a view just pulls the data from the underlying tables after all. ... Using indexes to improve query performance is not a new concept; however, indexed views provide additional performance benefits that cannot be achieved using standard indexes.