Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Keys Table - What means fields Maintain SQL Index .
nav_student
Member Posts: 175
Hi guys,
when i see the Keys of a table i see some fields
KeyGroups
Maintain SQL Index
MaintainsSIFTIndex
SQL Index.
What are this fields? Can i improve performance with this fields?
when i see the Keys of a table i see some fields
KeyGroups
Maintain SQL Index
MaintainsSIFTIndex
SQL Index.
What are this fields? Can i improve performance with this fields?
0
Comments
BTW: it is MaintainSIFTIndex not MaintainsSIFTIndex
Never stop learning
Van Vugt's dynamiXs
Dutch Dynamics Community
For example, with older NAV versions (pre Dynamic Cursor) the "SQLIndex" property (used correctly!) could help, with all newer NAV versions actually using it could screw up your system.
When it's about SIFT/VSift, this might be helpful:
http://dynamicsuser.net/blogs/stryk/archive/2010/05/29/optimizing-sift-and-vsift.aspx
If you are not sure about how to handle these "Key" options, then just leave them as they are ...
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool
The versions i´m talking are NAV 5.0 SP1 and NAV 2009.