Creating a Virtual Index for a Table

A virtual index saves physical storage, but can negatively impact runtime system performance. Carefully evaluate the need for the virtual index and the possible impact to your system. How Is a Database Space Saved Using a Virtual Index?

Create a Virtual Index for a Table

  1. On the File Definition form of the Database Definition tool (dbdef), select the desired product line and file.
  2. Press Define (F6).
  3. Select Indexes.
  4. In the Virtual field of the Index Definition form, enter Yes.
  5. Press OK twice to save the index.