Navision Table Optimization

Balello

Hi.
We have a database on SQL SERVER (a 3.6 db on a 4.01 client).
I need to do the table optimization (as in database information, tables, optimize) and it should run every night.
Is there a way to do that with simple scheduled "dos"-like command or a external procedure?
Thanks in advance.

stryk

Hi!

First: Why do you want to do that, and why every night?

The "Table Optimization" is doing two things:

1. Deleting "empty" SIFT records.
With your current version of NAV you should not do that; please follow this thread:
http://www.mibuso.com/forum/viewtopic.php?t=19387

2. Re-Creating Indexes.
You don't want to do that daily, and it is not necessary to do that. To "defragment" the indexes you should use a simple Maintenance Plan, running the Job weekly. Of course, there are advanced options to tune the system; if you search MIBUSO you'll find plenty of advice for performance optimization.

But to answer your question: No, you can't schedule it. Except if you use the "Table Optimizer" tool from Expand IT
http://www.expandit.com/templates/expandit.asp?catalog_id=1122
PLease have in mind, that the "benefits" mentioned in the ad are not CAUSED by this tool.

But as mentioned: you should not use the "Table Optimizer" anyway!