Is a

select *  from myView

faster than the query itself to create the view (in order to have the same resultSet):

select * from ([query to create same resultSet as myView])

?

It’s not totally clear to me if the view uses some sort of caching making it faster compared to a simple query.

16 Answers
16

Leave a Reply

Your email address will not be published. Required fields are marked *