I was improve a form and I tried modifing primary Index.
Table is SalesTable and index is SalesIdx but when I test on sql I recieve a stadistics that make me doubt if is necessary to add Partition and DataAreaId.
Current index fields order is Partition, DataAreaId and SalesId.
When I execute a query on sql I recieve this information:
In where clausere only salesId field.
Next step using all fields of index with right order.
With this stadistics I suppose that is better use less fields on where clausure.
Then I add partition and dataAreaId and order index with salesId, Partition, DataArea.
i sincronize salesTable and refresh table on sql to see the new order on sql.
And finally I decide to call where with only salesId field with the new order.
for more times I execute query I never get a better result of first execution, so my question is when we need to add partition and dataAreaId fields to an index?
For your information in my company we have several companys but only one partition
Regards
