Is Optimize Table still needed after Rebuilding Index?

superpuz

Hi,

I'm curious with this Optimize button on Database Information>Tables form. Will it still be needed if I Rebuilding the database index (from SQL Server maintenance) on daily basis?

In the help file, the optimize button brief explanation is:

To start the optimization process, which performs two functions:

For each Microsoft Dynamics NAV table, the SQL Server indexes, other than the primary key, are rebuilt to optimize their layout and usage.

For each SIFT structure, any entries that contain zero values in all numeric fields are removed. The removal of these redundant entries will free space and provide more efficient updating and summing of SIFT information.

Aren't those also what the rebuilding index do? and more?

What is the advantage of Optimize table, except for I can choose the table to optimize?

kine

Which NAV version? If <=4 than you still need to e.g. maintain SIFT tables (delete zero sum records).

superpuz

kine wrote:

Which NAV version? If <=4 than you still need to e.g. maintain SIFT tables (delete zero sum records).

Thx for the reply Kamil.

It means that optimize table is not needed for NAV editions after NAV 4.0 (NAV 5.0, NAV 2009 and NAV 2013), right? IF I've done the database maintenance (Rebuilding Index on the SQL Server).