Sample Header Ad - 728x90

Hiding an index on a view to other queries in SQL Server

3 votes
1 answer
281 views
I have a View that has an Index that I'd like to use for known queries. The issue is the existence of this Indexed View causes other queries to perform poorly. Is there a way to hide the Index or View so that it is only used when specifically included in a hint, or the ilk?
Asked by CWMjr (63 rep)
Mar 6, 2025, 08:24 PM
Last activity: May 16, 2025, 03:12 AM