You could see how the performance is if you drop the clustered index, after dropping the clustered index the view will just behave like a normal view.

Check what indexes are...

What index have you got on that view?

I'm not sure why the index recommendation has INCLUDE columns on it because it has to delete the row from the table.

Is there an FK to tblRecords_Unfiltered on tblAlert_Owners_Unfiltered? If...

How many rows are in tblAlert_Owners_Unfiltered?

It's probably going so slow as you have no indexes on the FK column on the child tables.

Set up data

drop table if exists #a
go
;WITH MyCTE([sessionnumber],[maxsession],[rownumber],[startdate],[startweekday],[enddate],[endweekday],[starttime],[endtime],[NomineeName])
AS
(
SELECT '1','8','1','7-Apr-24','Sunday','8-Apr-24','Monday','10:00 PM','1:00 AM','Name 1' UNION ALL
SELECT '1','8','2','7-Apr-24','Sunday','8-Apr-24','Monday','10:00 PM','1:00 AM','Name 2' UNION ALL
SELECT '1','8','3','7-Apr-24','Sunday','8-Apr-24','Monday','10:00 PM','1:00 AM','Name 3' UNION ALL
SELECT '1','8','4','7-Apr-24','Sunday','8-Apr-24','Monday','10:00...

IMHO, Steve Collins' post (with a tiny tweak (change fn.n to fn.value) in the 2nd bit of code) contains the winning entries for simplicity IF you don't mind...

If you install this DateRange function, this gives certainly the shortest SQL if not the fastest

select CONVERT(date, d.value) Date, 
  ...

If you install this DateRange function, this gives certainly the shortest SQL if not the fastest

select CONVERT(date, d.value) Date, 
    ...

CREATE VIEW must be in a batch by itself, i.e., without GOs, you could create only one view per script.

Since GOs are likely not valid, that may be what...

We use Windows Task Sheduler and SQL Agent jobs.

Did you mean "Dijkstra"?

My point is... the OP hasn't identified the scenario accurately enough to even try to determine which kind of testing needs to be...

Well you can test that too. I edited the original script I provided to do multiple inserts:

            
January 20, 2024 at 4:26 pm
            
#4364998

            
            
                                                
        

You could/should test it, here is an example of a test:

set statistics io, time off
set nocount on
go
drop table if exists #a;
create table #a(Id int, Date date, col1...