How to optimize tables in Microsoft Dynamics Nav Classic Client

Guideline to optimize tables in Microsoft Dynamics Nav Classic Client :

Optimization process will perform two functions:

For every table of Microsoft Dynamics Nav, the SQL Server indexes, except the primary key will be reconstructed to optimize their usage and layout.

Every entry with zero values in numeric fields will be discarded for SIFT ( SumIndexField Technology  ) structure. This will increase the efficiency of SIFT which result in to fast summing of fields with huge entries.

For optimization of tables in Microsoft Dynamics Classic Client

1). Go to "File" >>  "Database" >> "Information".

      As shown in screenshot below:

2). You will see the Database Information window, in which you will find all relevant information about your database. Click on "Tables" button.

      As shown in screenshot below:

3). You will be redirected to a new window  "Database Information (Tables) " , Here you can select the desired tables you want to optimize and click "Optimize" button.

      As shown in screenshot below:

Enjoyed the topic, Please do subscribe to our newsletter to get updated with every post without a miss.

Thanks for reading

Shubin Dongre