restoring a backup = automatic optimize on tables?

Tvis
Member Posts: 70
If i have a full .fbk file and restore it in a fresh database will the tables automatically be optimized?
It seems that this is what happens based on the size of the database im working with...
It seems that this is what happens based on the size of the database im working with...
0
Comments
-
Part of the restore is a rebuiling of all the keys which will optimize your database0
-
No, it optimizes everytime you do a backup and restore.
The tables also optimizes if you make some change, then save & compile it.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
deadlizard wrote:The tables also optimizes if you make some change, then save & compile it.
In case you change/create an index and comile&save it, this index will be optimized because it has been modified/created.
The prove for this : if you would save an object of a BIG table, saving it would cost a lot of time.Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!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