Hello, In SQL Server Management Studio for SQL Server 2014 using the "Maintenance Plan Wizard" setting up 2 tasks I have the following questions:
[Reorganize Index] - Seems like the "Compact large objects" option saves some type of space but what impact does it have on performance or anything else when it runs or concerns afterwards?
[Update Statistics] - Is it better in general to select 'Full scan' as Scan type or if specify number what value is general rule of thumb?
Is it correct the order should be Reorganize first and then Update Statistics?
Thanks in advance.