Re-Organize Indexes on SQL2005 VS Navision Tables Optimize ?

Simo_ba

Hi Guys,
can someone show me the difference between doing Re-Organize Indexes on SQL2005 and running Navision Tables Optimize.

in case that i will run one of them or both.

Thanks a lot.

aohlfsen

Navision Optimize will also delete zero records in sift-tables.

Besides this there can be other differences between the way you choose to reindex from SQL 2005 and the CREATE INDEX WITH DROP_EXISTING that Navision performs.

B.R.

Simo_ba

Thanks for this infos