Several years ago I ran Database Tuning Advisor on our database. Then the database wasn't very big so it was easy.
I implemented the suggestions, and it created several views with names like _dta_mv_xxx
I have never written a query against those views, and I wonder if they are used in any way by SQL-Server. I can't see any indexes on the views either.
Is it safe to delete those views or will it impact performance?
The database is around 400 gb so working with creating and recreating indexes is slow.
The database is SQL Server 2016 Enterprise.