Problem:
How can I turn off the NoJoinOpt filter for a catalog when using the Data Manager?
Resolution:
Sometimes, the Relativity Data Manager's optimization filters do not work properly for Joins. This results in less efficient joins and poor performance. The following instructions will turn off the Join Optimization.
First, backup your registry settings, then follow these steps:
1) On the Data Manager system, start the registry editor, regedt32.
2) Navigate to:
HKEY_LOCAL_MACHINE\\Software\\ODBC\\ODBC.INI\\dsn
where dsn is the name of the data source for the catalog. This will make the change only on the specific data source desired.
3) Create a new string "NoJoinOpt" and give it the value of "1".
Now re-create the scenario where the problem occurs, and check the results.
