Submitted by Nathan Clouse on 03/15/22.
Let’s explore what keywords forceSelectOrder and ForceNestedLoop do.
Introduction
The database access layer in X++ largely conceals it magic from us as developers and we hope it gets the SQL right – and it does. SQL is largely 99.9%…
Continue Reading Nathan Clouse’s Article on their blog
Select FirstOnly vs Select FirstOnly ForceSelectOrder ForceNestedLoop
Let’s explore what keywords forceSelectOrder and ForceNestedLoop do. Introduction The database access layer in X++ largely conceals it magic from us as developers and we hope it gets the SQL right – and it does. SQL is largely 99.9% accurate and about 95%-ish optimized for the workload presented.
Blog Syndicated with Nathan Clouse’s Permission
More About This Author
