SP3 - ClusteredIndex missing again ?

Mogens
Mogens Member Posts: 10
edited 2006-10-24 in NAV/Navision Classic Client
Is it just me, or is the ClusteredIndex property disabled again on all tables ?

Version NAV 4.0 SP3 W1

Only table 21,37,77,210,313,8601 has ClusteredIndex

...or perhaps they don't want to change all the tables, but expecting us to use the fix tool.

Comments

  • ara3n
    ara3n Member Posts: 9,258
    The PK is clustered by default on sql. It's just not there by default on navision objects. Take a look in SQL Studio management for the tables. You'll see that the PK is clustered.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • bbrown
    bbrown Member Posts: 3,268
    SQL does not require Primary Key Contraints to be tied to Clustered Indexes. If you create the Primary Key using the Enterprise Manager - Table Designer the Primary Key will be tied to a Clustered Index. However it is possible to relate it to a nonclustered index using transact-sql. Navision implements with Primary Key = Clustered Unique Index to support its ISAM type behavior on SQL.
    There are no bugs - only undocumented features.

Categories