SQL SERVER TABLE INDEX
SELECT a.index_id, name, avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats (DB_ID(), OBJECT_ID(N'PRODDTA.F0911'),
NULL, NULL, NULL) AS a
JOIN sys.indexes AS b ON a.object_id = b.object_id AND a.index_id = b.index_id;
GO
I get the following results:
1 F0911_PK 0,433147917092651
2 F0911_1 0,569241808179861
3 F0911_6 0,651252541263223
4 F0911_8 0,702117043267517
5 F0911_9 1,00642172860301
6 F0911_10 1,19874025096048
7 F0911_11 0,941720801981586
8 F0911_12 0,620834794808839
9 F0911_13 0,879430556567791
10 F0911_15 32,7026897902632
11 F0911_17 29,0688220383567
12 F0911_18 49,8233908948195
13 F0911_19 25,8356763511403
14 F0911_23 47,6356938019383
15 F0911_24 49,3505974503457
16 F0911_25 47,5397788450035
17 F0911_27 49,8800248837278
18 F0911_28 47,120537613066
19 F0911_29 44,8183315373198
20 F0911_30 22,1129903308217
21 F0911_32 26,7378789391368
22 F0911_33 44,8658536585366
23 F0911_34 31,6307011775958
24 F0911_35 48,8758476786646
25 F0911_36 25,7980979595482
I trie some to to do manuel rebuild and reorganization via sql . My Question is to know are the any JDE tool to solve index grow size.