Hi:
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?
Thanks!
Software Engineer
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?
Thanks!
Software Engineer
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.