Article ID: 102895 - Last Review: December 3, 2003 - Revision: 2.1

How Increase & Decrease Size of Compound Structural Index

View products that this article applies to.
This article was previously published under Q102895

On This Page

Expand all | Collapse all

SUMMARY

To increase the size of a compound structural index file, repeat the INDEX ON command. To reduce the size of the .CDX file, issue the REINDEX command, or delete the tag and issue the INDEX ON command.
Back to the top

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.
Back to the top
APPLIES TO
  • Microsoft Visual FoxPro 3.0 Standard Edition
  • Microsoft FoxPro 2.5b
  • Microsoft FoxPro 2.5a
  • Microsoft FoxPro 2.0
  • Microsoft FoxPro 2.5b for MS-DOS
Back to the top
Keywords: 
KB102895
Back to the top
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations