Data Model Optimization

If a Nectari View is running with an unacceptable time response given the data volume, the first thing to do is to determine whether the View is based on a Data Model or a Cube. In the case of a Cube, see the next subsection. If it is a Data Model, do the following:

1. Use the Nectari Log to see and copy the SQL Query of the Data Model. (Refer to Traces and Logs to determine where the Nectari Log file is located.)
2. Paste and run the Query in a standard SQL client (e.g. SQL Server Management Studio) directly on the server.
3. Analyze the query to determine ways to optimize it, such as adding useful indexes to the database.
   Note

   You should use caution when adding indexes to a Sage ERP SQL Server Database as they might get deleted during upgrades if you did not use a specific Sage ERP tool to add them.