Neoview SQL Reference Manual (R2.4)

SUM function use of, 456
VARIANCE function use of, 475
DML operations on materialized views
restrictions for, 66
DML statements (see Data Manipulation Language (DML)
statements)
DOUBLE PRECISION data type, 239
DROP INDEX statement
authorization and availability requirements, 109
examples of, 109
syntax diagram of, 109
DROP MATERIALIZED VIEW statement
example of, 110
syntax diagram of, 110
DROP MVGROUP statement
example of, 111
syntax description of, 111
DROP SCHEMA statement
authorization and availability requirements, 112
example of, 112
syntax diagram of, 112
DROP SYNONYM statement, 113
considerations, 113
example of, 113
syntax diagram of, 113
DROP TABLE statement
authorization and availability requirements, 114
description of, 114
examples of, 114
syntax diagram of, 114
DROP TRIGGER statement
authorization and availability requirements, 115
description of, 115
example of, 115
syntax diagram of, 115
DROP VIEW statement
authorization and availability requirements, 116
example of, 116
syntax diagram of, 116
DROP VOLATILE INDEX statement
examples of, 109
syntax diagram of, 109
DROP VOLATILE TABLE statement
authorization and availability requirements, 114
examples of, 114
syntax diagram of, 114
E
Embedded INSERT
examples of, 182
restrictions on, 173
Error messages, 37
EST_TOTAL_COST field, 124
EXCLUSIVE lock mode, 29
EXECUTE statement
considerations for, 118
examples of, 118
scope of, 118
syntax diagram of, 117
EXISTS predicate
correlated subquery within, 272
examples of, 272
syntax diagram of, 272
EXP function
examples of, 379
syntax diagram of, 379
EXPLAIN function
columns in result, 380
examples of, 382
operator tree, 380
syntax diagram of, 380
EXPLAIN output columns
CARDINALITY, 127
DESCRIPTION, 127
DETAIL_COST, 127
EST_TOTAL_COST, 124
LEFT_CHILD_SEQ_ NUM, 126
MODULE_NAME, 126
OPERATOR, 126
OPERATOR_COST, 127
PLAN_ID, 126
REQUESTS_IN, 122
REQUESTS_IN field, 122
RIGHT_CHILD_ SEQ_NUM, 126
ROWS_OUT, 122
SEQ_NUM, 126
STATEMENT_NAME, 126
TNAME, 127
TOTAL_COST, 127
Explain statement
displayed, 120
operators, 120
OPTIONS ’e’ considerations, 124
OPTIONS ’f’ considerations, 121
OPTIONS ’m’ considerations, 126
OPTIONS ’n’ considerations, 122
output, 122
reviewing query execution plans, 120
syntax, 120
Expression
character (or string) value, 240
datetime value, 242, 243, 247
description of, 240
interval value, 243, 247
numeric value, 250
Extended numeric precision, 232
Extensions
reserved words, 501
statements, 36
EXTRACT function
examples of, 383
syntax diagram of, 383
F
File options
CREATE INDEX use of, 59
CREATE TABLE use of, 70
Fixed-length character column, 234
520 Index