Well, that sounds cool right? Like, never index hinting in NAV anymore after all the discussions in the past.
With NAV 2013 it is no longer possible to setup index hints using the $ndo$dbconfig table.
Does it mean it's no longer nescesairy.
I found out about this during an upgrade of one of my customers from NAV2009 RTC to NAV2013.
We experienced extremely slow performance in an area where NAV2009 was much faster than NAV2013. And here I promised better performance... DAMN.
Off course with our perfect documentation (not) it took some time to figure out it might be that index hinting was used in NAV2009 to force SQL using an index it would not use normally.
The process is selecting shipments to be planned in a trip for a taxicompany. We use a common method to select a shipment using the user id, just like you would when applying customer and vendor ledger entries. When selected it's an extremely selective field (only one or two record of a million have this value) but SQL does not pick it up because... because... shoot me, I don't know why not. DAMN 2.
So with index hinting no longer possible (confirmed by Microsoft, done on purpose, by redesign) I needed to be creative.
The solution is to save a pointer to a shipment in a second table called "Selected Shipment". All shipment that need to be planned in a trip are temporarily stored there and picked up and deleted afterwards. Depending on the architecture of your transaction this could even be done in a temporary table and/or a single instance codeunit.
So recap: no more indexhinting, be carefull with upgrades and creative with solutions.
And PS: The general performance of NAV 2013 is AWESOME!!!
Recently Packt Publishing released two great new books about Microsoft Dynamics NAV 2013.
Implementing Microsoft Dynamics NAV 2013
This book is written by Laura & Cristina Nicolas and it covers the functional part of the application and especially the how to implement NAV.
Programming Microsoft Dynamics NAV 2013
Written by one of my best friends David Studebaker and his son Chris. Here they cover the technical aspects of the application, how to enhance the functionality.
Packt was kind enough to send me copies of both books to review and post on my blog. Currently I am reading both books and my findings will be online shortly.
And what about your book Mark?
This is a question I've been asked many times last year. I regret to say that due to personal priorities I have decided not to update my book for NAV 2013 yet. With 4 young kids growing up and me being part of that process it would simply be impossible. My wish would have been to update the book with the theories of the Partner Ready Software methodology which honestly would mean a major rewrite of the book. An update with just the application changes covered between 2009 and 2013 would be to simple in my opinion.
So watch my blog for the reviews and don't hesitate to order both books!
I would like to quote David Machanick: "You only need to learn one thing from the book to justify the purchase". And I can promise each and every reader that this will be the case.