vasoov
Active Member
My database is divided into 2 filegroups, PRIMARY and INDICES. Currently the clustered indices of the top 50 largest tables reside in the INDICES filegroup. INDICES is 45GB insize and PRIMARY is 5GB in size. All nonclustered indices are also in the INDICES filegroup
PRIMARY resides on a 65GB RAID 5 (18GB x5), and INDICES on a 65GB RAID 0+1 (18GB x8)
Question: Is it correct to place the clustered indices into the INDICES filegroup. Some people say that the clustered index should reside together with the data (PRIMARY) and nonclustered should be placed in the INDICES filegroup.
Has anyone got any specific index tuning tips for JDE. In my case I had to manually add a nonclustered index on F4211 on SDKCOO, SDTRDJ field as certain queries were taking 5 minutes. With the index this came down to 7 seconds!
PRIMARY resides on a 65GB RAID 5 (18GB x5), and INDICES on a 65GB RAID 0+1 (18GB x8)
Question: Is it correct to place the clustered indices into the INDICES filegroup. Some people say that the clustered index should reside together with the data (PRIMARY) and nonclustered should be placed in the INDICES filegroup.
Has anyone got any specific index tuning tips for JDE. In my case I had to manually add a nonclustered index on F4211 on SDKCOO, SDTRDJ field as certain queries were taking 5 minutes. With the index this came down to 7 seconds!