Posted inDynamics NAV & BC
Select with partially matching index: can we make it faster?
Let's assume we want to select a set of customer ledger entries based on two values: salesperson code and the payment reference. Or any subset of records from any other table that satisfies two criteria: the table is large enough, so the query can benefit from…