prov:value
| - NAV would create the indexes like this:$0: z$1: a,b,c, z$2: e,f, zFor the NCI $2 the SQL Server would internally maintain the CI fields; thus $2 actually is designed like this:$2: e,f, z (a,b,c)> This should work optimally for filters on e, f, z and mostly a, b, c.When copying the NAV Key a,b,c and e,f to SQL Index 1:1 the indexes will be like this:$1: a,b,c $2: e,f (a,b,c)> $1 should perform
|