mibuso.com

Microsoft Business Solutions online community
It is currently Sat Nov 01, 2014 12:39 am

All times are UTC + 1 hour




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Understand Keys Fields - How this improve performance?
PostPosted: Fri Jun 17, 2011 3:00 pm 
Offline

Joined: Mon Aug 10, 2009 11:24 am
Posts: 150
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?


Top
 Profile E-mail  
 
 Post subject: Re: Understand Keys Fields - How this improve performance?
PostPosted: Fri Jun 17, 2011 6:51 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 5:11 pm
Posts: 9067
Location: 3rd rock from sun
Country: United States (us)
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.

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: