Comments on Keep It Simple and Fast: Index statistics and suggestions of a table in one...

oh cool, thanks you very much for your help,

2009-09-01T00:35:57.008+02:00

oh cool, thanks you very much for your help,

Is this the only result set? The table GBKMUT is u...

2009-08-28T21:19:15.202+02:00

Is this the only result set? The table GBKMUT is used in a lot of different ways depending on the functionality you are using in Exact Globe or Exact Synergy. Within Exact we are running a project to improve the index structure of the Exact Globe. Index suggestions of customers are very valuable for us. Within Exact we have made an application (ftp://ftp.exact.nl/Software/ESI/ExactSysInfo.zip) which helps you to improve the configuration of your SQl Server. It also sends statistical data to Exact about how a customer is using our software. One example of this statistical data are the index suggestions. Based on these suggestions we are going to improve the index structure of Exact Globe. Feel free to contact me if you want join the pilot phase for this project.

this is my result, is there a problem? --MISSING-...

2009-08-28T20:49:34.560+02:00

this is my result, is there a problem?

--MISSING-- --NONCLUSTERED-- 25.48
--MISSING-- --NONCLUSTERED-- 99.38
--MISSING-- --NONCLUSTERED-- 21.07
--MISSING-- --NONCLUSTERED-- 65.47
--MISSING-- --NONCLUSTERED-- 71.47

and have a overlaping index
IX_gbkmut_SOnr
IX_gbkmut_MRP