Maybe the subject is little bit wrong but here is what I would like to know.
I have development and production environment that are pretty much similar. I'm running navision 4 sp3 and with client monitor check in one specific report. For the one specific command (that is repeated for several times) on development I see the same query every time, select top 1 null. But, on production, first three times it executes select top 500 *, and the rest is select top 1 null.
Based on what Navision could decide to issue different commands for the same navision command, even in the same running (production)?