A query that I composed and am currently running is doing so very slowly.
The query contains references to two views. I'm thinking about adding a clustered index to each view to improve performance and ultimately get the query to run faster.
But, if I add an index to a view, does it also add that index to the underlying tables of the view and cause issues for those tables?
Incidentally, I tried to add a clustered index to one of the views. But, SQL would not do it because the view is not schema bound. How do I make it schema bound? If I do this, will doing so negatively affect its underlying tables?
Are there other ways of speeding up the run of a query other than adding indexes and removing references to unnecessary tables, as I just did?