Neoview SQL Reference Manual (R2.2)

Derived column names
examples of, 191
syntax of, 191
DETAIL_COST in EXPLAIN output
CPU_TIME, 111, 340
IDLETIME, 111, 341
IO_TIME, 111, 340
MSG_TIME, 111, 340
PROBES, 111, 341
DIFF1 function
equivalent definitions, 334
examples of, 334
syntax diagram of, 334
DIFF2 function
equivalent definitions, 336
examples of, 336
syntax diagram of, 336
DISK POOL , 77
considerations for, 77
restrictions for, 78
DISTINCT clause
aggregate functions, 152, 279
AVG function use of, 293
COUNT function use of, 310
MAX function use of, 361
MAXIMUM function use of, 361
MIN function use of, 362
STDDEV function use of, 409
SUM function use of, 413
VARIANCE function use of, 430
DML operations on materialized views
restrictions for, 64
DML statements (see Data Manipulation Language (DML)
statements)
Documents, related information, 26
DOUBLE PRECISION data type, 206
double-byte Unicode character set, 190
DROP INDEX statement
authorization and availability requirements, 93
examples of, 93
supporting a constraint, 93
syntax diagram of, 93
DROP MATERIALIZED VIEW statement
syntax diagram of, 94
DROP MVGROUP statement
example of, 95
DROP MVGROUP statement, syntax description of, 95
DROP SCHEMA statement
authorization and availability requirements, 96
examples of, 96
limits, 441
syntax diagram of, 96
DROP SYNONYM statement, 97
syntax diagram of, 97
DROP SYNONYM statements
considerations, 97
versioning considerations, 97
DROP TABLE statement
authorization and availability requirements, 98
examples of, 98
syntax diagram of, 98
DROP TRIGGER statement
authorization and availability requirements, 99
syntax diagram of, 99
DROP VIEW statement
authorization and availability requirements, 100
examples of, 100
syntax diagram of, 100
DROP VOLATILE INDEX statement
examples of, 93
supporting a constraint, 93
syntax diagram of, 93
DROP VOLATILE TABLE statement
authorization and availability requirements, 98
examples of, 98
syntax diagram of, 98
E
embedded inserts, restrictions on, 152
error messages, 39
EST_TOTAL_COST field, 108
EXCLUSIVE lock mode, 31
EXECUTE statement
considerations for, 102
examples of, 102
scope of, 102
syntax diagram of, 101
EXISTS predicate
correlated subquery within, 238
examples of, 238
syntax diagram of, 238
EXP function
examples of, 338
syntax diagram of, 338
EXPLAIN function
columns in result, 339
examples of, 341
operator tree, 339
syntax diagram of, 339
EXPLAIN output columns
CARDINALITY, 111
DESCRIPTION, 111
DETAIL_COST, 111
EST_TOTAL_COST, 108
LEFT_CHILD_SEQ_ NUM, 110
MODULE_NAME, 110
OPERATOR, 110
OPERATOR_COST, 111
PLAN_ID, 110
REQUESTS_IN, 106
REQUESTS_IN field, 106
RIGHT_CHILD_ SEQ_NUM, 110
ROWS_OUT, 106
SEQ_NUM, 110
STATEMENT_NAME, 110
TNAME, 111
TOTAL_COST, 111
Explain statement
453