What is Smart SQL and does anyone have any documentation?

jackharris

I see that there's an option to disable it, but I wanted more info on what it was and whether there was any documentation that I could review with my team as to whether we should enable it for our clients?

bbrown

"Smart SQL" is what allows NAV\BC to retrieve data from multiple related tables by sending a single complex SQL query. Think joins. It should always be enabled (default setting) except when investigating the performance of said queries.

When it is disabled, the data for each table is retrieved separately. As in the way old NAV worked.

cgimec

Smart SQL should always be enabled unless you want to debug and you don't want to spend time braking down the queries.
Disabling it might help you find the slow queries a bit quicker. It works beautifully with Extended Events and it helps a lot knowing which process is slow so you can replicate and trace.