Thanks for all the feedback. I would be putting appropriate indexes and if the view is reusable then would create the view.

Thanks again.

My tables in concern dont have indexes as it was causing delays because of frequent inserts and updates happening on that table.

Question 1. If I do create a view, can...

Interesting.

Thanks again.

Thanks,

" ..there wouldn't be any difference in the actual execution plan" was what I was looking for.

That means that the data or query plan is not cached for views...

use tempdb

go

create table a (b int)

go

insert into a (b) values (1), (2), (3)

select * from a

begin tran

truncate table a

select * from a

rollback tran

select * from a

drop table a

This would ideally...