SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-22
S
SQL/MP (continued)
local autonomy 12-6
logging 10-5
options and performance 10-32
PATHMON DEFINEs 10-10
query plans 10-12
SQL SENSITIVE flag 10-6
SQL VALID flag 10-6
statistics 10-12
STOREDDEFINES option 10-32
execution cost 13-9
initializing 2-4, 2-6
installing 2-1, 2-2
measurement models 13-8
migrating to a new version 2-10
node name for system 12-3
objects
archiving 4-17
distributed 12-1, 12-8
PUP LABEL issues 11-31
PUP RENAME issues 11-32
purging 9-33
removing B-1
restoring 11-2
programs 10-5, 10-7
recompilation
automatic 10-7
, 14-25
RECOMPILE option 10-7
RECOMPILEONDEMAND
option 10-7
recorded time 10-4
removing B-1
removing from a node B-1
SENSITIVE flag 10-6
software components 2-2
startup cost 13-8
statistics area 13-4
system requirements 2-1
VALID flag 10-5, 10-6
SQL/MP statements
ADD CONSTRAINT 10-16
ALTER INDEX 10-16
ALTER TABLE 10-16
ALTER VIEW 10-16
CLOSE 10-14
CREATE INDEX 10-16
DECLARE CURSOR 10-41
DELETE 10-41
DROP CONSTRAINT 10-16
DROP INDEX 10-16
DROP TABLE 10-16
DROP VIEW 10-16
FETCH 10-14
GET CATALOG 10-41
GET VERSION OF PROGRAM 10-13,
10-41
INSERT 10-41
LOCK 10-41
OPEN 10-14
RENAME 10-16
SELECT 10-41
UNLOCK 10-41
UPDATE 10-41
UPDATE STATISTICS 10-16
SQL_CMP_DOUBLE_SBB_OFF
DEFINE 14-21
SQL_CMP_DOUBLE_SBB_ON
DEFINE 14-21
SQL_EXE_DOUBLE_SHUTOFF
DEFINE 14-19
Startup cost, SQL/MP 13-8
Statements, execution costs 13-9
Statistics
catalogs 14-7
displaying 13-3
execution 13-9
FILE entity 13-8
improving query plan 14-7
Measure collection 13-5/13-11