The reports installed with CRM will run much faster if they are optimized. To optimize your reports, find the Database Manager program under the RealNex folder in your Windows Start menu:
When Database Manger opens, click the Connect button and enter your SQL password:
Once you are connected to your database, click the Advanced tab and select the Optimize Reports button:
Click OK to begin the optimization:
It can take up to 45 minutes to optimize the reports. You can use your computer and CRM while this process runs in the background.