For NAV it doesn’t make a difference if it could find a “Zero SIFT Record” or no SIFT record for a query – in both cases the value 0 is processed (=returned?).
www.mibuso.com/forum/viewtopic.php?t=16985
Post by stryk on Tue Apr 22, 2008 8:15 am
---
Navision keeps the SIFT (Sum Index Field Technology) values in dedicated tables that are updated using triggers. In certain situations the trigger does not update the value but replaces it with 0 and creates a new record with the correct value.
This means that the size of the database increases significantly especially if the 'SIFT-tables' are active.
When the tables are optimized the SIFT-tables are recreated from scratch and the zero-records are deleted.
www.expandit.com/1122/Table+Optimizer+and+NAV+SQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment