Slow index builds
Posted in 1998
Hi, Something strange happens when I try to build two indices on table foo using Online 4.10.UD2 on SCO 3.2.4.2. The first, on column bar1 of type CHAR(8) takes around 15 minutes. The second, on column bar2 of type CHAR(10) takes around 24 hours. Why is there such a *huge* difference? If anybody has any suggestions as to how to speed up this second index build I'd be delighted to hear them. Here's the tbcheck -pt output: TBLSpace Report for foodb:foo Physical Address 200017 Creation date 05/21/98 00:20:30 TBLSpace Flags 1 Page Locking Maximum row size 692 Number of special columns 0 Number of keys 2 Number of extents 4 Current serial value 1 First extent size 1000000 Next extent size 500000 Number of pages allocated 3500000 Number of pages used 3416016 Number of data pages 3342547 Number of data bytes 331117060 Number of rows 6685093 Extents Logical Page Physical Page Size 0 f00003 1000000 1000000 e00003 500000 1500000 1000003 1000000 2500000 1100003 1000000