Neoview SQL Reference Manual (R2.3)

CARDINALITY, 113
DESCRIPTION, 113
DETAIL_COST, 113
EST_TOTAL_COST, 110
LEFT_CHILD_SEQ_ NUM, 112
MODULE_NAME, 112
OPERATOR, 112
OPERATOR_COST, 113
PLAN_ID, 112
REQUESTS_IN, 108
REQUESTS_IN field, 108
RIGHT_CHILD_ SEQ_NUM, 112
ROWS_OUT, 108
SEQ_NUM, 112
STATEMENT_NAME, 112
TNAME, 113
TOTAL_COST, 113
Explain statement
displayed, 106
operators, 106
OPTIONS ’e’ considerations, 110
OPTIONS ’f’ considerations, 107
OPTIONS ’m’ considerations, 112
OPTIONS ’n’ considerations, 108
output, 108
reviewing query execution plans, 106
syntax, 106
Expression
character (or string) value, 218
datetime value, 220, 221, 224
description of, 218
interval value, 221, 224
numeric value, 227
Extensions
reserved words, 459
statements, 38
EXTRACT function
examples of, 353
syntax diagram of, 353
F
File options
CREATE INDEX use of, 58
CREATE TABLE use of, 69
Fixed-length character column, 211
FLOAT data type, 216
FLOOR function
examples of, 354
syntax diagram of, 354
FORMAT keyword, 76
FULL join, description of, 150
Functions, ANSI compliant, 38
G
GET SERVICE statement
syntax of, 117
GRANT EXECUTE statement
authorization and availability requirements, 120
examples of, 121
syntax diagram of, 120
GRANT SCHEMA statement
authorization and availability requirements, 123
examples of, 123
syntax diagram of, 122
GRANT statement
authorization and availability requirements, 119
examples of, 119
privileges, 255
syntax diagram of, 118
H
Histogram tables
UPDATE STATISTICS use of, 186
Histograms
clearing, 185
HOUR function
examples of, 355
syntax diagram of, 355
I
Identifiers, 230
IDENTITY columns, 76
IN predicate
examples of, 250
logical equivalent using ANY, 250
operand requirements, 250
syntax diagram of, 249
Index keys, 232
Indexes
CREATE INDEX statement, 58
CREATE VOLATILE INDEX statement, 58
description of, 231
indexes and materialized views, 63
inner equi-join query, definition of, 64
INSERT function
examples of, 356
syntax diagram of, 356
INSERT statement
access options, 126
compatible data types, 127
considerations, 126
examples of, 128
lock modes, 126
ORDER BY clause, 125
query expression within, 125
syntax diagram of, 124
target column list, 124
VALUES specification within, 127
INSERT, self-referencing, 126
INTEGER data type, 216
Interval data type
description of, 214
examples of literals, 238
Interval literals
description of, 236
examples of, 238
Interval value expression
examples of, 224
476 Index