Estimating space requirements for an index


You can use SSE to estimate space requirements for an index.

Important

Space estimation is not available for XML objects, LOB objects, or objects that have partial statistics.

To estimate space requirements for an index

  1. From the command prompt, type SSE and press Enter.
  2. On the Space Estimation panel, enter IX in the Object Type field, and press Enter.
  3. Estimate space requirements for the index as follows:
    1. Change any of the modifiable values (highlighted in the figure in Space-requirement-estimates-based-on-user-specified-values) as needed to correspond to your index.

      Important

      For more information about a specific field, press F1.

    2. Press Enter to update the Estimated fields:

      • The Estimated box on the right side of the panel displays estimates for the index .
      • The Estimated list in the bottom right corner shows estimates for the index .

      Important

      The bottom of the panel shows more information about the index. In the Cmd column, you can enter I to insert, R to repeat, or D to delete lines.

  4. (Optional) If you want to see additional estimates based on different values, repeat Step 3.
  5. When finished, press END to exit.



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*