Oracle8i Generic Documentation Master Index

qualifier

using subprogram name as, PLS 2-37

when needed, PLS 2-35, PLS 2-39

Queries

pass-through SQL, DDS 7-7

queries, SQL 5-18, SQL 7-544

ad hoc, SCN 26-31

association with cursor, PCO 5-12

association with cursors, PC_ 6-11

avoiding the use of indexes, STU 6-7

comments in, SQL 5-18

composite indexes, SCN 10-22

compound, SQL 5-20

defined, SCN 23-4

optimization of, SCN 23-27

ORs converted to, SCN 23-10

correlated

left correlation, SQL 7-547

default locking of, SCN 27-26

define phase, SCN 16-12

defined, SCN 23-3, SQL 5-18

describe phase, SCN 16-12

dictionary views, SRF 1-45

distributed, DDS 1-11, SQL 5-25, STU 8-1, STU 8-10

application development issues, DDS 4-3

distributed or remote, DDS 1-11, SCN 33-11

during prepare phase, DDS 3-3

enabling parallelism for, STU 26-8

ensuring the use of indexes, STU 6-6

errors in distributed queries, ADG 10 - 47

fetching rows, SCN 16-12

forwarding, PC_ 3-14

grouping returned rows on a value, SQL 7-549

hierarchical. See hierarchical queries

hints, SRF 1-88

hints in, SQL 5-18

in DML, SCN 16-3

incorrectly coded, PC_ 6-8

index scans parallelized by partition, SCN 26-5

inline views, SCN 10-16

join, SQL 5-21

kinds of, PC_ 6-6

location transparency and, DDS 1-15, SCN 33-15

locking rows during, SQL 7-551

merged with view queries, SCN 10-14

multirow, PCO 5-7

optimizing IN subquery, SCN 23-17

optimizing view queries, SCN 23-15

ordering output, NLS 2-25

ordering returned rows, SQL 7-551

outer joins in, SQL 7-547, SQL 7-548

parallel processing, SCN 26-2

passthrough SQL, DDS 7-3

phases of, SCN 27-5

post-processing, DDS 4-3

processing, SCN 16-12

read consistency of, SCN 1-32, SCN 27-5

referencing multiple tables, SQL 5-21

remote, DDS 4-3

remote execution, DDS 4-3

requirements for, PC_ 6-7

restricting results of, SQL 7-548

returning more than one row, PC_ 6-7

SAMPLE clause

cost-based optimization, SCN 22-16

select lists of, SQL 5-18

selecting from a random sample of rows, SQL 7-546

selecting from specified partitions, SQL 7-546

selectivity of, SCN 23-51

set membership

optimizing, ADG 18 - 20

single-row versus multirow, PC_ 6-8, PCO 5-8

sorting results, SQL 5-20

star queries, SCN 24-14

stored as views, SCN 1-24, SCN 10-11

syntax, SQL 5-18

table scans parallelized by rowid, SCN 26-4

temporary segments and, SCN 4-18, SCN 16-12

top-level, SQL 5-18

top-N, SQL 2-56

transparency, DDS 2-25

triggers use of, SCN 20-23

unnesting, ADG 18 - 13

VARRAY, ADG 18 - 16

queries parallelized statistic, SRF C-14

query, NET 6-36, NET 8-17, PCO 5-7

explicit describe, OCI 4-13

query column, SQL trace, STU 14-13

QUERY command, NET 6-36, NET 8-17

A.SMD record, NET 6-68, NET 8-17, NET A-45

CNAME.SMD, NET 8-17, NET A-45

DLCR.TDBMS.OMD record, NET 8-17, NET A-45

DL.RDBMS.OMD, NET 8-17, NET A-45

NS.SMD, NET 8-17, NET A-45

of NAMESCTL, reference, NET A-45

V1ADD.NPO.OMD, NET 8-17, NET A-45

query delta joins, STU 31-11

query plan, STU 13-1

query rewrite, SCN 10-17

and dimensions, SQL 7-260

and function-based indexes, SQL 7-87

and the rule-based optimizer, SQL 7-87

consistency level, SQL 7-88

correctness, STU 31-18

defined, SQL 7-544

disabling, SQL 7-87, SQL 7-106

dynamic predicates in security policies, SCN 30-23

enabling, SQL 7-87, SQL 7-106, STU 31-3, STU 31-4

hints, STU 31-4, STU 31-21

initialization parameters, STU 31-4

matching join graphs, STU 29-6

methods, STU 31-6

privileges, STU 31-4

QUERY REWRITE system privilege, SQL 7-496, SQL 7-497, SQL 7-499

query. See SQL query

query server process

about, SAD 4-13

tuning, STU 21-14

query work area, PLS 5-16

QUERY_REWRITE_ENABLED parameter

of ALTER SESSION, SQL 7-87

of ALTER SYSTEM, SQL 7-106

QUERY_REWRITE_INTEGRITY parameter

of ALTER SESSION, SQL 7-88

querying

recovery catalog, SBR 7-2

queue

deferred transactions, REP 2-4

queue messages wait event, SRF A-45

queue monitor process (QMNn), SCN 1-20, SCN 8-13, SCN 19-6

interval statistics, SCN 19-11

window of execution, SCN 19-7

queue size, adjusting for connection requests, NET 8-13

queue subscribers, definition, ADQ 1-23

queue tables

downgrading, MIG 12-31

upgrading, MIG 7-29

queue tables, definition, ADQ 1-15

QUEUE_PRIVILEGES view, SRF 2-179

queues, definition, ADQ 1-15

queuesize, NET 3-14, NET 6-70

QUEUESIZE parameter, NET 6-70, NET 8-13

for adjusting listener queue size, NET 3-14, NET 6-70, NET 8-13

queuing, SCN 19-2

queuing system, DDS 5-3

quiescing

and fine grained quiesce, REP A-3

master groups, REP 2-22

replicated schemas, SPR 34 - 75, RAR 8-160

QUIT command

of LSNRCTL, reference, NET A-8

of NAMESCTL, reference, NET A-47

see STOP command for CMCTL

see STOP NOW command for CMCTL

QUOTA clause

of ALTER USER. See CREATE USER.

of CREATE USER, SQL 7-427

quotas

listing, SAD 23-22

revoking from users, SAD 23-14

revoking tablespace access and, SCN 29-14

setting to zero, SAD 23-14, SCN 29-14

SYS user not subject to, SCN 29-14

tablespace, SAD 23-13, SCN 1-43, SCN 29-13

temporary segments ignore, SCN 29-14

tablespace quotas, SAD 9-3

temporary segments and, SAD 23-14

quotation marks

table names and, SUT 1-25, SUT 2-29

use with database object names, SUT 5-19

quoted identifier, PLS 2-6