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
What the codeunit that runs on the backend when you push Optimize?
ReplyDelete