Over the weekend, I rebuild the indexes for our largest file for claim details. This file has about 41 million records in it. The directory for the dynamic file says it uses 35 gig of space. So it is a pretty good sized file.
Prior to rebuilding the indexes, they were contained in 8 separate files idx001 - 8. After the rebuild, the indexes were contained in 5 parts, idx001 - 5. So I got back more than 4 gig of space back by doing the rebuild. We are trying to evaluate now if selects using indexes are any faster after the rebuild. I am not sure of how the internal structures of the B-Tree index could get more than 4 gig of extra infrastructure doing balancing or whatever. We never delete anything out of this file. I guess the bottom line for us will be regularly scheduled rebuilds of our large indexes on a rotating schedule. Below is the picture of the Unix Dir before the rebuild and after that the structures after the rebuild Before # cd /usr/ud/mcc13/CLM.DETAIL # ls -l total 78538312 -rwxrwx--- 1 root mcc 1999994880 Dec 14 10:25 dat001 -rwxrwx--- 1 root mcc 1999994880 Dec 11 18:41 dat002 -rwxrwx--- 1 root mcc 1999994880 Dec 11 19:23 dat003 -rwxrwx--- 1 root mcc 1999994880 Dec 11 17:05 dat004 -rwxrwx--- 1 root mcc 1999994880 Dec 11 19:19 dat005 -rwxrwx--- 1 root mcc 1999994880 Dec 11 19:12 dat006 -rwxrwx--- 1 root mcc 1999994880 Dec 11 18:07 dat007 -rwxrwx--- 1 root mcc 394174464 Dec 11 19:22 dat008 -rw-rw-rw- 1 root mcc 1999998976 Dec 14 12:15 idx001 -rw-rw-rw- 1 root mcc 1999998976 Dec 11 18:55 idx002 -rw-rw-rw- 1 root mcc 1999998976 Dec 11 16:12 idx003 -rw-rw-rw- 1 root mcc 1999998976 Dec 11 18:06 idx004 -rw-rw-rw- 1 udtcron mcc 1999998976 Dec 11 16:11 idx005 -rw-rw-rw- 1 epops mcc 1999998976 Dec 11 17:04 idx006 -rw-rw-rw- 1 udtcron mcc 1999998976 Dec 14 13:06 idx007 -rw-rw-rw- 1 cjhedl is 65200128 Dec 14 13:06 idx008 -rwxrwx--- 1 root mcc 1999994880 Dec 11 19:12 over001 -rwxrwx--- 1 root mcc 1969758208 Dec 11 18:41 over002 -rwxrwx--- 1 root mcc 1514889216 Dec 11 19:23 over003 -rwxrwx--- 1 root mcc 1485086720 Dec 11 17:05 over004 -rwxrwx--- 1 root mcc 1527906304 Dec 11 18:43 over005 -rwxrwx--- 1 root mcc 1481752576 Dec 11 19:12 over006 -rwxrwx--- 1 root mcc 1470455808 Dec 11 18:06 over007 -rwxrwx--- 1 root mcc 302186496 Dec 11 19:22 over008 Now the After: total 70523120 -rwxrwx--- 1 root mcc 1999994880 Dec 19 16:18 dat001 -rwxrwx--- 1 root mcc 1999994880 Dec 19 16:18 dat002 -rwxrwx--- 1 root mcc 1999994880 Dec 19 16:17 dat003 -rwxrwx--- 1 root mcc 1999994880 Dec 19 16:17 dat004 -rwxrwx--- 1 root mcc 1999994880 Dec 19 16:17 dat005 -rwxrwx--- 1 root mcc 1999994880 Dec 19 16:18 dat006 -rwxrwx--- 1 root mcc 1999994880 Dec 19 16:17 dat007 -rwxrwx--- 1 root mcc 394174464 Dec 19 16:16 dat008 -rw-rw-rw- 1 root mcc 1999998976 Dec 19 16:12 idx001 -rw-rw-rw- 1 root mcc 1999998976 Dec 19 16:18 idx002 -rw-rw-rw- 1 root mcc 1999998976 Dec 19 16:18 idx003 -rw-rw-rw- 1 root mcc 1999998976 Dec 19 16:16 idx004 -rw-rw-rw- 1 root mcc 1912913920 Dec 19 16:18 idx005 -rwxrwx--- 1 root mcc 1999994880 Dec 19 16:17 over001 -rwxrwx--- 1 root mcc 1983873024 Dec 19 16:18 over002 -rwxrwx--- 1 root mcc 1521885184 Dec 19 16:17 over003 -rwxrwx--- 1 root mcc 1490575360 Dec 19 16:15 over004 -rwxrwx--- 1 root mcc 1531142144 Dec 19 16:17 over005 -rwxrwx--- 1 root mcc 1486102528 Dec 19 16:18 over006 -rwxrwx--- 1 root mcc 1475420160 Dec 19 16:17 over007 -rwxrwx--- 1 root mcc 303702016 Dec 19 16:16 over008 ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/