(Self experience) Things that better not be executed during office hours
1. Updating Analysis View card
2. Changing key field value (for example, Customer No.)
What Tables > Optimize does?
From Online Help:
For each Navision table, the SQL Server indexes, other than the primary key, are rebuilt to optimize their layout and usage.
For each SIFT structure, any entries that contain zero values in all numeric fields are removed. The removal of these redundant entries will free space and provide more efficient updating and summing of SIFT information.
---
Recommendations:
1) get rid of all those high SIFT buckets, leaving only one
2) add optimized SQL Server site Indexes – indexes we unfortunately cannot create from NAV site
Source:
Optimizing SIFT and VSIFT
http://dynamicsuser.net/blogs/stryk/archive/2010/05/29/optimizing-sift-and-vsift.aspx
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment