curious_sqldba (8/12/2013)
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?
I don't want to hi-jack this thread by answering a forum post. I'll take a look at your original post and answer there.
--Jeff Moden
Change is inevitable... Change for the better is not.