Change primary key on Object table

damir
damir Member Posts: 28
edited 2008-03-28 in NAV/Navision Classic Client
I have made some analysis on production SQL Server database and found that most used queries are ones involving Object table.

Since primary key (Type,Company Name,ID) on this table has low selectivity, I was wondering if changing it to "ID,Type, Company Name" will bring performance improvement.

I have tried this on my local server. It is working but I am not sure if performance is improved.

What do you think of this idea?

Comments

  • DenSter
    DenSter Member Posts: 8,307
    It's one of the worst ideas I've ever seen!!!

    No just kidding :mrgreen:

    You're right it isn't very selective, but I wouldn't touch the design of a system table. What would probably help is increase the object cache on the client session, that way objects are kept in memory.
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories