Hi all,
In navision you have the possibilitie to create tempory indexes; in de designer of NAV, you have the property "MaintainSQLIndex”. When this is set to FALSE, the index is not maintained at database level, but can be used within NAV, for e.g. sorting in a report. The index is generated run-time.
Does Jet use these temporary indexes? This would be a great way to avoid tablescans!
-Ramon
0 comments
Please sign in to leave a comment.