2022.1

set @a=null,@c=null,@b=concat("show tables where",ifnull(concat("
`Tables_in_",database(),"` like '",@c,"' and"),'')," (@a:=concat_ws
(',',@a,`Tables_in_",database(),"`))");
Prepare `bd` from @b;
EXECUTE `bd`;
DEALLOCATE PREPARE `bd`;
set @a:=concat('optimize table ',@a);
PREPARE `sql` FROM @a;
EXECUTE `sql`;
DEALLOCATE PREPARE `sql`;
set @a=null,@b=null,@c=null;
If using Microsoft SQL Server run the following command in a query window:
sp_updatestats
Windows 10 Search service impacting Connect
The Windows 10 Search service runs as a background task, indexing files and folders. It has
been noted that this background task is sometimes preventing files being added to the Connect
temporary files folder when large amounts of files are being output and copied.
If this is an issue for you, we suggest disabling Search Indexing on the
C:\Users\<username>\Connect folder.
This issue will be fixed in a later release.
Job Creation Presets: External Sorting change introduced in 2018.2
Versions prior to 2018.2 did not correctly save the line end characters for external sort
configurations in Job Creation Presets, which meant the job could not be externally sorted. This
issue has been fixed in version 2018.2. However, Job Creation Presets created with an earlier
version may still have the wrong line end character for external sorting. To fix this, open the Job
Creation Preset in the new version, reset the line end setting in the sorting options and then
save the preset.
Page 115