SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-25
V
Unique index keys and performance 5-47
Unique indexes 3-18, 5-47
UNLOCK statement 10-41
UNRECLAIMED FREESPACE flag 7-24
Unstructured files 8-7
UP option (PUP) 11-33
Update operation, WITH CHECK 3-15
UPDATE statement 10-41
UPDATE STATISTICS statement
adding indexes 7-5
description 14-7/14-11
effect on performance 14-8
program invalidation 10-2, 10-16
testing 14-9
UPGRADE CATALOG command 2-14
UPGRADE SYSTEM CATALOG
command 2-15
Upgrading programs 2-12
UPSHIFT attribute 5-28, 10-29
USAGES catalog table
description 6-1
displaying 9-34
purging data 7-35
securing 5-7, 7-15
shorthand view creation 5-40
USAGES table 10-16
User ID, security 4-4, 5-1
User-defined primary key
composition 3-2
generic locks 14-21
key-sequenced tables 3-2
table organization 5-11
User-defined transaction 2-14, 4-16
Utilities, moving databases 9-2
V
Valid definition 6-5
VALID flag
automatic recompilation 10-6
description 10-4/10-5
VALID flag (continued)
invalidation 10-16
VALIDDEF flag 6-5
Validity
program 10-4
protection view 3-15
VARCHAR columns
defining for faster access 5-21
displaying 6-5
performance issues 5-21
VERIFIEDWRITES file attribute, similarity
check rules 10-28
VERIFY utility
detecting invalid programs 10-4
determining database consistency 6-12
Version
catalog information 6-15
requirements 2-1, 2-10
reverting 2-15
VERSIONS catalog table
description 5-3
displaying information 6-15
Version, reverting 2-15
Views
See also Protection views
See also Shorthand views
adding 7-4
altering attributes 7-18
backing up 4-22
contents 9-21
creating 5-38/5-41, 7-4
database layout 3-16
description 3-13, 3-16
displaying information 6-5
distributed databases 12-7
dropping 7-30
file labels 9-21
moving 9-14, 9-21
NO DEFAULT clause 7-33
performance issues 14-24