Indexing issue

[Souvik]

Hi,
I have a view based on a select from two underlying tables. These tables have a non-clustered index on the column used in the join for the view. But a select * on the view takes about the same time, even if I take out the indices from the underlying table. Is it then not guaranted that the optimizer uses the undrelying indices on the tables??
Many thanks,

 

[dinzana]

You can force the use of indices by including index hints . Take a look at Books Online (BOL) index hints.

I hope that this helps,

dinzana