I've scheduled job with statistics update on 100GB database (some of them were really old, from several months to 2-3 years), job ended succesfully after 20minutes at 1AM.
Now i checked Query Store (after 15 hours ~) and there are several regressed queries with markedly worse execution plans. Average times are significantly worse than one day before update stats.
What should i do now? Do you think DBCC FREEPROCCACHE could help? Thanks a lot
PS: SQL Server is version 2019, but database has Compatibility Level set on 100 (2008). Idk why, this is our new customer. This will be changed soon.