SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-20
S
Security (continued)
recommendations 4-4
Safeguard 4-8
schemes 4-4
shorthand view 3-15, 5-40
system catalog 5-10
table 5-37
user IDs 4-4, 5-1
view 5-38, 7-18
SELECT statement
NOREGISTER 10-41
performance 5-47
views 14-24
SENSITIVE flag 10-6
Sequential cache 14-17
SERIALWRITES file attribute, similarity
check rules 10-28
Servers
constraints 14-23
remote 12-11
SET SESSION STATISTICS ON
command 13-1, 13-3
SET STYLE VARCHAR_WIDTH
command 6-5
Shadow labels 11-36
SHADOWSONLY option 11-36
Shorthand views
description 3-15
securing 3-15, 5-40
Similarity check
ALLOCATE file attribute 10-28
AUDIT attribute 10-28
BUFFERED file attribute 10-28
column headings 10-28
comments 10-28
creation timestamp 10-27
description 10-15
example 10-25, 10-35
execution-time name resolution 10-41
EXTENT file attribute 10-28
Similarity check (continued)
file attributes 10-28
help text 10-28
key tags 10-27
LOCKLENGTH attribute 10-28
MAXEXTENTS file attribute 10-28
NOPURGEUNTIL attribute 10-28
NOREGISTER option 10-41
number of columns 10-28
number of indexes 10-27
OWNER file attribute 10-28
parallel execution plans 10-16
partitioning attributes 10-27
protection views 10-28
redefinition timestamp 10-25, 10-26,
10-27
SERIALWRITES file attribute 10-28
statistics 10-28
table contents 10-27
table names 10-27
TABLECODE file attribute 10-28
tables 10-27
timestamps, creation 10-27
underlying tables 10-27
VERIFIEDWRITES files attribute 10-28
Site update tape (SUT) 2-2
SLACK option
APPEND command 8-16
LOAD command 8-7, 9-21
RELOAD command 8-3
SMALLINT data type 5-22
SMF
catalog tables 5-7
CREATE INDEX example 5-46
creating indexes 5-45
creating partitions 5-32
creating tables 5-18
displaying physical file names 6-10
displaying virtual file names 6-10