SIFT

omyvadiya
omyvadiya Member Posts: 124
edited 2013-08-22 in NAV/Navision Classic Client
Hi,
I am new to navision, i have read the SIFT technology, only one query.
We define SumIndexField to a key, but how we know to which key we have to assign the SumIndexField.
As in Customer table, For Balance field Flowfield is defined. How can it be related to the key and which key.
Please clarify.

Comments

  • kriki
    kriki Member, Moderator Posts: 9,127
    NAV is intelligent enough to figure out which key it can use to calculate the flowfield. It scans the keys of the underlying table 1 by 1 and if it finds a key with SIFT-fields that can be used, it will use that key.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • vaprog
    vaprog Member Posts: 1,173
    At least on a native db, the key needs to include all fields on which a (flow-)filter is set. I am not sure whether this requirement is relaxed on an SQL server environment, but probably not (I am not talking about the SQL Server index nor the SQLIndex, MaintainSQLIndex properties here).

    Furthermore, NAV uses the first key that matches the requirements, not the best one.
  • kriki
    kriki Member, Moderator Posts: 9,127
    SQL has the same requirements but you can opt to change the index in SQL (SQLIndex-property), to maintain or not the SQL Index (MaintainSQLIndex-property) or to maintain or not the SQL SIFT (MaintainSIFTIndex-property).

    In NAV2013, it is not necessary anymore to have a key in NAV anymore! You can calculate SIFT-fields in any way conceivable without having a SIFT-key for it.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories