How Increase & Decrease Size of Compound Structural Index

MORE INFORMATION

Steps to Reproduce Problem

1. In the Command window, issue the following commands:

         USE D:\FOXPROW\TUTORIAL\CUSTOMER EXCLUSIVE
         **The command above assumes FoxPro version 2.5 for Windows
         COPY TO TEST
         USE TEST EXCLUSIVE
         INDEX ON CNO TAG CNO
         CLOSE ALL
         FILER

2. Find TEST.CDX in Filer and note its size. Close Filer.
3. In the Command window, issue the following commands:

         USE TEST EXCLUSIVE
         INDEX ON CNO TAG CNO
          **A warning may appear about overwriting tag cno. It will be
          **necessary to overwrite the tag.
         CLOSE ALL
         FILER

4. Find TEST.CDX in Filer and note the increase in size. Close Filer.
5. In the Command window, issue the following commands:

         USE TEST EXCLUSIVE
         REINDEX
         CLOSE ALL
         FILER

6. Find TEST.CDX in Filer and note that its size has been reduced.