Home > MultiValue Central > Online D3 Reference > TCL > tcl.nframe-index

tcl.nframe-index

Verb: Access/TCL, Releases: AP

Displays total number of frames used by index or indices.

Syntax

nframe-index file.reference a.code nframe-index file.reference *

Description

produces a total of the number of frames in use by a specific 'b-tree' index, or all indices if indicated by an '*' (asterisk).

'a.code' specifies the 'a (algebraic)' processing code to be used in forming the keys to the index. The processing code must include an attribute number.

The '*' (asterisk) designates 'all' indices. Either an 'a' processing code or an '*' (asterisk) must be specified.

Example

nframe-index invoices a1
Total of 67 frames counted.

This indicates that 67 frames are in use by the index which defines attribute
one of the 'invoices' file.

nframe-index invoices *
nframe-index invoices a1
Total of 67 frames counted.
nframe-index invoices a2
Total of 29 frames counted.
nframe-index invoices a3
Total of 53 frames counted.
nframe-index invoices a23
Total of 18 frames counted.
nframe-index invoices a27
Total of 105 frames counted.
nframe-index invoices a0
Total of 26 frames counted.

See Also

Command Name Type Description
pc.index.fdi Processing Code Maintains the root.fid of the index.
processing.codes Definition Overview of processing codes.
b-tree Definition Balanced-tree index.
tcl.verify-index Verb: Access Verifies b-tree indices.
tcl.create-index Verb: Access Creates new b-tree index.
pc.a Processing Code Defines algebraic processing expression.
tcl.delete-index Verb: Access Deletes b-tree index.
access.istat Verb: Access Performs distribution analysis on existing file modulo.
filename.file-of-files Definition Statistical information on all files.

User Comments

What do you think?

Share your experience or ask a question by using the form below.

Login to leave your comments.