Hi, Does anyone have any experience of changing the SQL index that is clustered? In Navision by default it is the primary key that is clustered, but we have found from tests in Query analyser that we can get better performance on Customer Ledger Entry by having an index on Customer No. clustered and leaving Entry No. the primary key and a normal index. Is there any way to implement this through Navision? I can’t see any options for choosing whther a key is clustered. Many thanks Justin
The clustered property is not exposed in Navision at all, so you can only do it manually.