Which one faster either view or sql query?

Question

Which one faster either view or sql query? Please note that both view and sql query having the sql statements.

score 1 · Answer 1 · answered Jul 22 '11 at 18:15

They should be equivalent.

A view is essentially just the result set of a stored query, using all the same indexes and data pages as the underlying tables.

Views can have additional indexes added to speed up operations like aggregates. See indexed views.

score 0 · Answer 2 · edited May 23 '17 at 12:04

0

This question provides good answers already, check it out!

edited May 23 '17 at 12:04

Community

answered Jul 22 '11 at 18:12

John Humphreys

2 Answers2