Environment
Micro Focus Filr 4.x
Microsoft SQL Server version 2016
Microsoft SQL Server version 2017
Situation
Filr performance, such as browsing files, logging in, loading files, etc is very slow when the database server is Microsoft SQL Server versions 2016 or 2017
Resolution
Refer to the Microsoft SQL Server documentation to enable LEGACY_CARDINALITY_ESTIMATION.