Understand Keys Fields - How this improve performance?

nav_student
Member Posts: 175
Hi guys,
i´m newbie on Nav and i had some doubts for the Fields of the Keys Table. I want to know what impact they can do the performance of NAV.
I have read this http://msdn.microsoft.com/en-us/library/dd338617.aspx.
Field KeyGroup
Explanation: Keygroups - Determines which key groups the key is a member of. By making the key a member of a predefined key group you can have the key defined and only enable it when it is going to be used.Adding a large number of keys to a database table decreases performance. However, by making the keys members of predefined key groups you can have the necessary keys defined and only activate them when they are going to be used, thus improving performance.
1 -Can you explain how adding a large number of keys can decreased performance?
2- Why understand how works Clustered Indexes an NCI. Tell me if i had a new record this indexes (CI, NCI) are updated right way? If so this decreases performance?
Field MaintainSQLIndex Property
1 -This option has always to e selected for every key ( PK or SK)?
Thanks in advance for your explanations?
i´m newbie on Nav and i had some doubts for the Fields of the Keys Table. I want to know what impact they can do the performance of NAV.
I have read this http://msdn.microsoft.com/en-us/library/dd338617.aspx.
Field KeyGroup
Explanation: Keygroups - Determines which key groups the key is a member of. By making the key a member of a predefined key group you can have the key defined and only enable it when it is going to be used.Adding a large number of keys to a database table decreases performance. However, by making the keys members of predefined key groups you can have the necessary keys defined and only activate them when they are going to be used, thus improving performance.
1 -Can you explain how adding a large number of keys can decreased performance?
2- Why understand how works Clustered Indexes an NCI. Tell me if i had a new record this indexes (CI, NCI) are updated right way? If so this decreases performance?
Field MaintainSQLIndex Property
1 -This option has always to e selected for every key ( PK or SK)?
Thanks in advance for your explanations?
0
Comments
-
It's a good idea, but never works in real life. Every db is tuned differently because the data is different. So creating key groups doesn't make sense.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions