Re-Organize Indexes on SQL2005 VS Navision Tables Optimize ?

Simo_baSimo_ba Member Posts: 78
edited 2008-02-04 in SQL Performance
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.

Comments

  • aohlfsenaohlfsen Member Posts: 30
    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_baSimo_ba Member Posts: 78
    Thanks for this infos
Sign In or Register to comment.