User guide

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-004 2-5
• Custom Tress. . Displays a customized version of the Object Tree.
You may perform most of the database administration functions on
the objects in the Custom Tree from this display. User can create
multiple custom trees. Refer to Chapter 3, Using the Object Tree,
for detailed instructions.
• Catalogs. Displays catalog-management menu buttons that allow
you to create, alter, drop, and upgrade catalogs. Refer to Chapter
11, Managing Catalogs, for detailed instructions.
• Tables. Displays table-management menu buttons that you can use
to create, alter, drop, tables, and more. Refer to Chapter 12,
Managing Tables, for detailed instructions.
• Views. Displays view-management menu buttons that you can use
to create, alter, drop, and rename views, and more. Refer to
Chapter 13, Managing Views, for detailed instructions.
• Indexes. Displays index-management menu buttons that you can
use to create, alter, drop, and rename indexes, and more. Refer to
Chapter 14, Managing Indexes, for detailed instructions.
• Programs. Displays program-management menu buttons that you
can use to alter, drop, compile, copy, move, and rename programs.
Refer to Chapter 17, Managing Programs, for detailed instructions.
• Table Partitions. Displays table partition-management buttons that
you can use to design, view, add, alter, drop, and move table
partitions. Refer to Chapter 15, Managing Table Partitions, for
detailed instructions.
• Index Partitions. Displays index partition-management buttons
that you can use to design, view, add, alter, drop, and move index
partitions. Refer to Chapter 16, Managing Index Partitions, for
detailed instructions.
• QueryAnalysis. Analyzes the performance of ad hoc queries or
queries used in existing programs. Refer to Chapter 7, Analyzing
and Tuning Query Performance, for detailed instructions
• Data. Manages stored data. You can query the data, copy data
between tables and files, or load data between tables and files. Refer
to Chapter 8, Managing Data, for detailed instructions.