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)