Hi, Last week, while transfering my own indices from one DB to another, I noticed the Navision Indices are all in the form of: “Create Unique Index…” My personal ones are all in the form of (created directly using enterprise Manager and Query Analyser): “Create Index…” Going back to the Object Designer and look at the Key properties page… I didn’t see the “unique” setting anywhere. Now, this is very bad because a lot of our Indices are definitely not “Unique”. And I have been noticing that a lot of “Navision” Created indices do not seem to have any effect at all (speedwise). So, I am wondering, anyone notice similar problem? Thanks.
Navision always implicitly has the primary key as part of any key (index) that may otherwise be created on the table besides the primary key allthough this doesn’t show in the Object designer.
Interesting… I didn’t notice that. It must be the reason why the SQL server do not use these key very often. I find that 50% of the time SQL server do not use Navision’s Keys. I ended up creating the keys in SQL server. It explains a lot. Thanks.
quote:
Originally posted by ohlfert
Navision always implicitly has the primary key as part of any key (index) that may otherwise be created on the table besides the primary key allthough this doesn’t show in the Object designer.