Thank you for sharing this article. Actually i had this question posted in forums also, so far no response, would like to know your thoughts please.

I have a view which is performing a order by on three columns a/b/c, a/b are indexed and is from table 1, c is from table2. How are the indices used in this case? How does sql use two different indices on two different tables? I am trying not to use indexed views or is indexing the view only way?