SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-23
T
Statistics (continued)
performance 13-1, 14-8
program execution 13-9
similarity check rules 10-28
SQL compilation 10-12
SQLCI STATISTICS option 13-3
SQLPROC report 13-6
SQLSA 13-5
SQLSTMT report 13-7
UPDATE STATISTICS 14-7/14-11
updating for tables and columns 14-7
STATUS command 8-4
Status information in programs 13-4
STOREDDEFINES option
COMPILE option 10-25
during SQL compilation 10-32
Subvolume names, name resolution 10-13
SUSPEND command 8-4
SUT (Site Update Tape) 2-2
Swap files 5-44
Swap file, index creation 5-44
SYSKEY column
combined with clustering key 3-3
description 3-3, 5-11
System catalog
creating 2-5
description 1-3, 5-4
displaying information 6-4
moving 9-9
PHYSVOL option 2-5, 5-7
security 5-10
table (CATALOG) 6-15
SYSTEM command 12-3
System requirements 2-1
System-defined primary keys 3-3, 5-11
T
Table contents, similarity check rules 10-27
TABLECODE file attribute, similarity check
rules 10-28
Tables
See also Base tables
adding 7-3
allocating space 5-14
appending data 8-7, 8-13, 8-15
attributes
altering 7-16
determining 6-10
specifying 5-16
audited 4-11
auditing 4-12, 4-13, 9-5
catalogs
description 5-2
indexes 5-3
command summary 1-10
constraint considerations, loading 5-53
controlling access 14-1
copying data 8-7, 8-13
creating 5-10, 7-3
creating views 5-38
database layout 3-13
description 3-13
displaying information 6-4
distributed databases 12-7
dropping 7-30, 10-2
dropping data 8-18
entry-sequenced 3-1, 3-9, 5-14
key-sequenced
creating 5-11
description 3-1
file structure 3-6
key levels 3-4
loading 5-53, 7-27, 8-7
local partitions 12-9
matching data types 5-29
moving 9-14, 9-16, 9-23
opens statistics 13-9
organization 5-10
partitioned 5-32, 14-25