I have a table with a clustered index and 2 non clustered index. Now, in my view I am selecting everything from my table
create view dbo.MyView
as
Select * from MyTable
Now, when I am using this view in my queries may I assume that this view will take advantage of the indexes created on the table. (i.e. work in the same way as Select * from MyTable should work)? or should I have to use Indexed views
Addition to the question
If view can take advantage of the table index, then using SELECT * FROM MyView Where SomeColumn = @someValue
may impact the performance badly (if view has large amount of data , so it will behave like a heap when not indexed).
How to overcome this issue ? other than using NOEXPAND (because I am using Enterprise edition)