Hi,
I saw Optimize in File -> Database -> Information-> Tables -> Optimize.
How can i run automatically this Optimize button with Batch Jobs????
Thanks & Regards,
kishore....
Assuming Native, I think the question is WHY do you want to optimize? It may save you a little bit of disk space, but disks are cheap, and the performance overhead is probably not worth it.
This is more a left over of the days when you had to pay for database space.
In SQL it's going to reindex and delete de zero records in the sift tables. This definitely helps performance.
On Native, I'm not sure what it does (you can't monitor it). I gues it's going to defragment (indexes?), which helps DB space ... which helps performance ... but don't expect too much of it.
Comments
http://www.expandit.com/
Native: Follow Mark's link
SQL: there are other options: Maintenance Plan, delete zero sift records (Using SQLPerform or Stryk's tools), ...
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
http://www.mibuso.com/forum/viewtopic.p ... tion+timer
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
Assuming Native, I think the question is WHY do you want to optimize? It may save you a little bit of disk space, but disks are cheap, and the performance overhead is probably not worth it.
This is more a left over of the days when you had to pay for database space.
Thanks & regards,
kishore.
On Native, I'm not sure what it does (you can't monitor it). I gues it's going to defragment (indexes?), which helps DB space ... which helps performance ... but don't expect too much of it.
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog