beautypg.com

HP Neoview Release 2.5 Software User Manual

Page 255

background image

To change the sort order of a displayed column:

Click the title of the column that you want to sort in ascending or descending order. See

“Sort and Move Data Columns” (page 47)

.

For more information on customizing the data grid, see

“Customize the Data Grid” (page 52)

.

In the SQL Objects Detail pane, these fields are displayed:

Description

Field or Option

The last time space data was captured.

Date Time

Specifies the SQL catalog name.

Catalog

Displays the SQL schema name.

Schema

Specifies the type of SQL object. The object type values are: base table (BT), materialized
view (MV), or index (IX).

Object Type

Specifies the SQL object name.

Object Name

Specifies the object name space as:

CN—Constraint

IX—Index

LK—Lock

TA—Table value object (table, view, stored procedure, SQL/MP alias)

TR—Trigger

TT—Trigger temp table

Object Name Space

The actual number of rows. This value may not be collected by the Inventory process
if the option is turned OFF. Obtaining this value increases total inventory time.

Row Count

Specifies the object size in megabytes (MB).

Object Size

Specifies the number of partitions for the SQL object. No partition is 0.

Number of Partitions

Displays the time and date when statistics were last updated.

Last Update Stats:

View the SQL Objects Detail

255