NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
D-51
DISPLAY USE OF Command
Although you did not display the statistics when you executed the command, you
can display them using the DISPLAY STATISTICS command as follows:
>> DISPLAY STATISTICS;
Estimated Cost 39
Start Time 94/06/01 09:07:16.678185
End Time 94/06/01 09:07:56.533061
Elapsed Time 00:00:39.854876
Master Executor Execution Time 00:00:00.359826
Records Records Disk Message Message Lock
Table Name Accessed Used Reads Count Bytes
\S.$V.I.S 48 42 4 84 6684
\S.$V.#2549 0 0 0 0 0
\S.$V.I.P 49 49 2 3 542
\S.$V.#2549 0 0 0 0 0
DISPLAY USE OF Command
DISPLAY USE OF is an SQLCI utility command that displays a list of SQL objects and
registered SQL object programs that depend on the object you specify.
object
is the name (or an equivalent DEFINE) of a collation, index, table, or view for
which to specify the dependent objects.
If object is a secondary partition, you must include either its node or the node that
contains the primary partition in the nodes you specify in the AT clause.
If ServerWare SMF is installed on your node, object cannot specify any object on
a $*.ZYS*. subvolume.
DISPLAY USE OF object [ AT { \node } ]
[ { (\node [,\node] ... ) } ]
[ , { BRIEF | STANDARD } ] ;