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?
0
Comments
No just kidding
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.
RIS Plus, LLC