Category Archives: Performance, Keys, Indexes, SQL Server

Everything I post about performance and Dynamics NAV nicely in one Category

NAV 2013 | No more Indexhinting


Editors Note : This blog post was brought forward from my previous blog. Well, that sounds cool right? Like, never index hinting in NAV anymore after all the discussions in the past. http://mibuso.com/forum/viewtopic.php?f=34&t=13154&hilit=hinting http://www.mibuso.com/dlinfo.asp?FileID=896 http://dynamicsuser.net/blogs/mark_brummel/archive/2007/08/21/is-navision-to-stupid-or-is-sql-to-smart.aspx With NAV 2013 it is … Continue reading

Posted in General, Performance, Keys, Indexes, SQL Server | Leave a comment

NAV2013R2 | Maintain SIFT Index


As I already explained in my last blog post the way performance tuning is done in NAV2013R2 has changed from previous versions. Rather than issueing a SQL Statement for each flowfield in each row on a listpage NAV now uses OUTER … Continue reading

Posted in General, Performance, Keys, Indexes, SQL Server | 3 Comments

NAV2013R2 | SQL Integer Issues


It’s been a while since I had time to blog, and still I do not really have the luxury of time but there are at least two things important enough to share. At the moment I am involved in a … Continue reading

Posted in General, Performance, Keys, Indexes, SQL Server | 3 Comments

NAV 2013 R2 | Keys, Keygroups and SetCurrentKey


With NAV 2013, the Classic Client and the Native Navision database were discontinued. One of the possibilities that arised was improving the SQL story in NAV. This was done first by implementing SETAUTOCALCFIELDS and the possibility to do CALCSUMS and … Continue reading

Posted in General, Performance, Keys, Indexes, SQL Server | Tagged , , , , , | 5 Comments

NAV 2013 | No more Indexhinting


By Mark Brummel, founder of NAV-Skills UPDATE: I’ve heard this was fixed in 2016. Dit not test this myself. Well, that sounds cool right? Like, never index hinting in NAV anymore after all the discussions in the past. http://mibuso.com/forum/viewtopic.php?f=34&t=13154&hilit=hinting http://www.mibuso.com/dlinfo.asp?FileID=896Continue reading

Posted in General, Performance, Keys, Indexes, SQL Server | Tagged , , | Leave a comment

NAV 2013 | SETAUTOCALCFIELDS


NAV 2013 | SETAUTOCALCFIELDS In NAV 2013 we have a new command SETAUTOCALCFIELDS. What does this command do. It is used in C/AL like this: Cust.SETAUTOCALCFIELDS(Balance) IF Cust.FINDSET THEN REPEAT Some Code UNTIL Cust.NEXT = 0; This leads to this … Continue reading

Posted in General, Performance, Keys, Indexes, SQL Server | Tagged , , , | 3 Comments

Table vs. Query | Performance Battle


Table vs. Query | Performance Battle NAV2013 introduced the Query object. Frankly I think that this new object type deserves more attention from bloggers. We have been nagging Microsoft for years to deliver this and now it is there and … Continue reading

Posted in General, Performance, Keys, Indexes, SQL Server | Tagged , , , | 4 Comments