Clustering in SQL

tapas6324
tapas6324 Member Posts: 35
edited 2008-02-12 in SQL General
The Primary Key of Value Entry Table is Clustured Index in SQL Server 2000 & we are going to change the key property to Non-Clustered in SQL.

So is there any bad impact from the Navision(Version 3.7) point of view????

Looking forward for your suggesion & thank you in advance.


Regards,
Paul
Tapas Paul,
Dubai, UAE.

Comments

  • bbrown
    bbrown Member Posts: 3,268
    Which key were you planning to set as the clustered index?

    Which client version are you using?
    There are no bugs - only undocumented features.
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Why?

    Have you tested this?

    The clustered index on entry no. is to make the posting process go fast. The speed of posting processes determines the usability of your system.

    If you have a reporting issue on a large database, I would recommend seting up a separate reporting database.

    How large is your database? How many end users do you have?
    Marije Brummel | Freelance Business Central Specialist
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories