Oracle8i Generic Documentation Master Index

I date format element, SQL 2-41

I variable in SQLDA

how value is set, PC_ 15-10

purpose of, PC_ 15-10

IAF GET statement

example, PCO 12-6

example of using, PC_ 20-5

in user exits, PC_ 20-4

purpose of, PC_ 20-4

specifying block and field names, PCO 12-6

specifying block and field names in, PC_ 20-5

syntax for, PC_ 20-4

using in user exit, PCO 12-5

IAF PUT statement

example, PCO 12-7

example of using, PC_ 20-6

in user exits, PC_ 20-5

purpose of, PC_ 20-5

specifying block and field names, PCO 12-7

specifying block and field names in, PC_ 20-6

syntax for, PC_ 20-5

using in user exit, PCO 12-6

IAP, PCO 12-12

IAP in SQL*Forms

purpose of, PC_ 20-13

IBM's NetView/6000, SCN 33-20

IBMsNetView/6000', DDS 1-20

ID column

PLAN_TABLE table, STU 13-4

identification

users, SAD 23-7

IDENTIFIED BY clause

of ALTER ROLE. See CREATE ROLE.

of CREATE ROLE, SQL 7-344

IDENTIFIED BY password clause

of CREATE DATABASE LINK, SQL 7-257

of CREATE USER, SQL 7-426

of SET ROLE, SQL 7-571

IDENTIFIED EXTERNALLY clause

of ALTER ROLE. See CREATE ROLE.

of ALTER USER. See CREATE USER.

of CREATE ROLE, SQL 7-344

of CREATE USER, SQL 7-426

IDENTIFIED GLOBALLY clause

of ALTER ROLE. See CREATE ROLE.

of ALTER USER, SQL 7-181

of CREATE ROLE, SQL 7-344

of CREATE USER, SQL 7-427

of CREATE USERIDENTIFIED BY clause

of ALTER USER. See CREATE USER.

identifier

forming, PLS 2-4

maximum length, PLS 2-5

quoted, PLS 2-6

scope rules, PLS 2-37

identifier, lock, SPS 7-8

identifiers, ORACLE

how to form, PC_ F-11, PCO F-10

identity, definition, OAS Glossary-3

Identix authentication method

see Oracle Advanced Security

Identix Biometric, system requirements, OAS 1-12

Identix TouchNet II Desktop Sensor, OAS 7-15

Identix TouchNet II Hardware Interface, OAS 7-4

IDEPTREE view, SRF 2-171

IDLE_TIME parameter

of ALTER PROFILE, SQL 7-64

of CREATE PROFILE, SQL 7-339

IDLM, SPS 8-1

block access synchronization, PSC 1-16

deadlock detection, PSC 1-16

defined, PSC 1-15

described, PSC 1-15

interacting with CM, PSC 1-6, PSC 1-16

LMDN process, PSC 1-15

LMON process, PSC 1-15

modification synchronization, PSC 1-16

IDLM parameters, SPS 18-12

IF statement, PLS 3-2

ELSE clause, PLS 3-3

ELSIF clause, PLS 3-4

syntax, PLS 11-86

THEN clause, PLS 3-3

IFILE, SRF 1-4

IFILE keyword

nested files, SRF 1-50

IFILE parameter, PSC 6-4, PSC 6-5, SPS 18-5, SRF 1-50

multiple files, SPS 18-7

overriding values, SPS 18-7

specifying identical parameters, SPS 18-6

iFS. See Internet File System

IGNORE

Import parameter, SUT 2-24, SUT 2-57

existing objects, SUT 2-48

IIOP, GTK 2-71, NET 4-13

configuring for SSL, NET 7-64

configuring the MTS_DISPATCHER parameter, NET 7-54

described, NET 7-50, NET 7-51

GIOP presentation layer, NET 2-14, NET 4-13

no session layer, NET 2-14

IIOP (Internet Inter-ORB Protocol), OAS Glossary-4

secured by SSL, OAS 9-7

IIOP clients

IIOP clients connections through listeners, NET 7-54

IIOP stack communications

described

ILMS, SCN 16-20

image copies, SBR 4-45

crosschecking, SBR 6-12

testing restore of, SBR 6-18

IMG, SMS 48-1

immediate (CR) block cleanout applications statistic, SRF C-11

immediate (CURRENT) block cleanout applications statistic, SRF C-11

IMMEDIATE clause

of SET CONSTRAINTS, SQL 7-568

immediate constraints, SCN 28-20

IMP, PSC 8-5, SMS 17-1

IMP_FULL_DATABASE role, SAD 24-5, SCN 30-22, SQL 7-503, SUT 2-7, SUT 2-11, SUT 2-23

Import, SUT 2-31

Implementing, NET 6-71, NET 7-12

implementing database design, SAD 1-20

implicit connections, PC_ 3-14

multiple, PC_ 3-15

single, PC_ 3-14

implicit cursor, PLS 5-11

attribute, PLS 5-38

implicit data conversion, SQL 2-31, SQL 2-33

implicit datatype conversion, PLS 2-27

effect on performance, PLS 5-67

implicit declaration

cursor FOR loop record, PLS 5-13

FOR loop counter, PLS 3-13

implicit dereferencing, ADG 16 - 24, SCN 13-10

implicit logons, PCO 3-15

multiple, PCO 3-16

single, PCO 3-15

implicit VARCHAR, PCO 4-30

Import, SUT 2-1

ANALYZE parameter, SUT 2-19

backup files, SUT 2-51

BUFFER parameter, SUT 2-19

CATEXP.SQL

preparing the database, SUT 2-7

character set conversion, SUT 1-53, SUT 2-56

character sets, SUT 2-55

COMMIT parameter, SUT 2-20

committing after array insert, SUT 2-20

compatibility, SUT 2-5

complete export file, SUT 2-43

consolidated extents, SUT 2-53

controlling size of rollback segments, SUT 2-20

conversion of Version 6 CHAR columns to VARCHAR2, SUT 2-65

creating an index-creation SQL script, SUT 2-26

cumulative, SUT 2-43

data files

reusing, SUT 2-21

database

reusing existing data files, SUT 2-21

DESTROY parameter, SUT 2-21

disabling referential constraints, SUT 2-14

displaying online help, SUT 2-24

dropping a tablespace, SUT 2-54

error handling, SUT 2-47

errors importing database objects, SUT 2-48

example session, SUT 2-34

export COMPRESS parameter, SUT 2-53

export file

importing the entire file, SUT 2-23

listing contents before import, SUT 2-28

failed integrity constraints, SUT 2-48

fatal errors, SUT 2-48, SUT 2-49

FEEDBACK parameter, SUT 2-22

FILE parameter, SUT 2-22

FROMUSER parameter, SUT 2-23

grants

specifying for import, SUT 2-23

GRANTS parameter, SUT 2-23

HELP parameter, SUT 2-9, SUT 2-24

IGNORE parameter, SUT 2-24, SUT 2-48

importing grants, SUT 2-13, SUT 2-23

importing objects into other schemas, SUT 2-13

importing rows, SUT 2-27

importing tables, SUT 2-28

incremental, SUT 2-43

specifying, SUT 2-25

INCTYPE parameter, SUT 2-25

INDEXES parameter, SUT 2-25

INDEXFILE parameter, SUT 2-26

INSERT errors, SUT 2-48

interactive method, SUT 2-41

invalid data, SUT 2-48

invoking, SUT 2-7

length of Oracle Version 6 export file DEFAULT columns, SUT 2-65

log files

LOG parameter, SUT 2-26

LONG columns, SUT 2-61

manually ordering tables, SUT 2-15

modes, SUT 2-5

NLS considerations, SUT 2-55

NLS_LANG environment variable, SUT 2-56

object creation errors, SUT 2-24

objects imported, SUT 1-5

OPTIMAL storage parameter, SUT 2-53

Oracle objects, ADG 18 - 41

Oracle Version 6 integrity constraints, SUT 2-65

parameter file, SUT 2-10, SUT 2-27

parameters, SUT 2-16

preparing the database, SUT 2-7

read-only tablespaces, SUT 2-54

recompiling stored procedures, SUT 2-61

RECORDLENGTH parameter, SUT 2-27

records

specifying length, SUT 2-27

reducing database fragmentation, SUT 2-46

refresh error, SUT 2-51

reorganizing tablespace during, SUT 2-54

resource errors, SUT 2-49

rows

specifying for import, SUT 2-27

ROWS parameter, SUT 2-27

schema objects, SUT 2-11, SUT 2-13

sequences, SUT 2-49

SHOW parameter, SUT 1-4, SUT 2-28

single-byte character sets, SUT 2-56

snapshot log, SUT 2-50

snapshot master table, SUT 2-51

snapshots, SUT 2-50

restoring dropped, SUT 2-51

specifying by user, SUT 2-23

specifying index creation commands, SUT 2-26

specifying the export file, SUT 2-22

storage parameters

overriding, SUT 2-53

stored functions, SUT 2-61

stored packages, SUT 2-61

stored procedures, SUT 2-61

system objects, SUT 2-13

table objects

import order, SUT 2-4

tables created before import, SUT 2-14

TABLES parameter, SUT 2-28

TOUSER parameter, SUT 2-31

transferring files across networks, SUT 2-50

unique indexes, SUT 2-25

uniqueness constraints

preventing import errors, SUT 2-20

user definitions, SUT 2-14

USERID parameter, SUT 2-32

using Oracle Version 6 files, SUT 2-65

import data, PSC 8-5

Import utility, PSC 8-5, SBR 13-16, SCN 1-6

about, SAD 1-17

Compatibility, SPS B-1

copying statistics, SCN 22-8

data definition conversion, MIG 2-13

database recovery, SBR 13-18

free lists, SPS A-20

migration, MIG 2-10, MIG 5-1

offline instantiation of master site, REP 8-17

partition maintenance operations, SCN 11-48

procedure for using, SBR 13-18

requirements for migration, MIG 5-2

restoring data, SPS B-1

restricted mode and, SAD 3-4

use in recovery, SCN 32-25

user-defined types, SCN 14-20

import_check, REP 7-17

importing

jobs, SAD 8-7

object groups

offline instantiation and, SPR 21 - 3, SPR 21 - 5, RAR 8-46, RAR 8-50

snapshots

offline instantiation and, SPR 22 - 2, SPR 22 - 3, RAR 8-55, RAR 8-57

status check, SPR 34 - 70, RAR 8-154

improving network performance

by adjusting SDU size, NET 3-13

by client load balancing, NET 3-12

by connection pooling, NET 2-50, NET 3-11

by randomizing client requests, NET 2-30, NET C-41

by using connection concentration, NET 3-11

with listener queuesize, NET 3-14

in avoiding dynamic extension, STU 20-28

in basic replication, REP 1-11, SCN 34-12

IN bind variables, DDS 7-5

IN comparison operator, PLS 2-46, PLS 5-5

IN operator, SCN 23-5

merging views, SCN 23-18

IN OUT bind variables, DDS 7-6

IN OUT parameter

of CREATE FUNCTION, SQL 7-269

of CREATE PROCEDURE, SQL 7-334

IN OUT parameter mode, ADG 10 - 6, PC_ 7-3, PCO 6-5, PLS 7-16

IN parameter

of CREATE function, SQL 7-269

of CREATE PROCEDURE, SQL 7-334

IN parameter mode, ADG 10 - 6, PC_ 7-3, PCO 6-5, PLS 7-14

in progress save set, LEG 2-8

IN subquery, SCN 23-17

inactive destination state

for archived redo logs, SAD 7-14

inactive online redo log

loss of, SBR 15-7

inactive session wait event, SRF A-33

inactive transaction branch wait event, SRF A-34

INAME option

when a file extension is required, PCO 14-2

INAME precompiler option, PCO 14-25, PC_ 10-25

incarnation of database option (RMAN)

list command, SBR 6-7

incarnation option (RMAN)

reset database command, SBR 6-7

INCLUDE

precompiler option, use of, PC_ 5-34

using to include the SQLCA, PC_ 9-16

INCLUDE precompiler option, PC_ E-3, PCO 14-25

INCLUDE statement

case-sensitive operating systems, PCO 2-23

declaring the ORACA, PCO 8-37

declaring the SQLCA, PCO 8-21

declaring the SQLDA, PCO 11-7

effect of, PCO 2-22

INCLUDE statements, PCO B-2

INCLUDING clause

of ALTER TABLE, SQL 7-144

INCLUDING CONTENTS clause

of DROP TABLESPACE, SQL 7-477

INCLUDING NEW VALUES clause

of ALTER MATERIALIZED VIEW LOG, SQL 7-57

of CREATE MATERIALIZED VIEW LOG / SNAPSHOT LOG, SQL 7-316

INCLUDING TABLES clause

of DROP CLUSTER, SQL 7-447

incompatibilities

removing, MIG 12-2

system-defined, MIG 12-4

incompatibilities, system-defined, MIG 8-6

incomplete media recovery

change-based, SBR 14-32 to SBR 14-35

definition, SBR 1-20, SBR 3-28

in OPS configuration, SBR 14-13

procedures for, SBR 14-26 to SBR 14-35

time-based, SBR 14-29 to SBR 14-31

using backup control file, SBR 14-13

incomplete object type, PLS 9-29

incomplete object types, ADG 16 - 16, SCN 14-17

creating, SQL 7-413

incomplete recovery

change-based (RMAN), SBR 9-25

log sequence-based (RMAN), SBR 9-26

time-based (RMAN), SBR 9-24

using RMAN, SBR 9-23

with a recovery catalog, SBR 9-24

without a recovery catalog, SBR 9-27

incomplete types, SQL 7-413

creating, SQL 7-411

inconsistent backups

definition, SBR 1-16

inconsistent whole database backups

definition, SBR 3-4

INCREMENT BY clause

of ALTER SEQUENCE. See CREATE SEQUENCE.

of CREATE SEQUENCE, SQL 7-351

incremental backups, SBR 8-21

differential, SBR 4-40

using RMAN, SBR 8-9

incremental checkpoint, SCN 8-8

incremental export, SBR 13-17, SUT 1-44

backing up data, SUT 1-49

command syntax, SUT 1-20

data selected, SUT 1-48

recording, SUT 1-23

restrictions, SUT 1-44

session example, SUT 1-49

specifying, SUT 1-20

SYS.INCFIL table, SUT 1-51

SYS.INCVID table, SUT 1-52

incremental growth, SPS 17-13

incremental import

parameter, SUT 2-25

specifying, SUT 2-25

incremental migration, REP B-4

incremental refresh, SCN 10-18

INCTYPE

Export parameter, SUT 1-20

Import parameter, SUT 2-25

IND synonym for USER_INDEXES, SRF 2-172

index

client, LEG 2-5

contention, SPS 19-6

creating, SPS 17-8

data partitioning, SPS 11-12, SPS 15-5

domain

creating, DCI 11-15

FREELISTS option, SPS 17-8

key compression, MIG 8-10

media, LEG 2-5

metadata for, DCI 11-37

PCM locks, SPS 15-5

save set status value in client index, LEG 2-9

using to improve performance, PCO D-6

index block split wait event, SRF A-34

INDEX clause

of CREATE CLUSTER, SQL 7-239

INDEX hint, SQL 2-59, STU 6-7, STU 6-16, STU 7-44

index join, STU 27-7

index joins, SCN 23-36, SCN 23-49

INDEX object privilege, SQL 7-508

index on physical ROWID, MIG 11-8

index options

SORTED INDEXES with SQL*Loader, SUT 5-43

SQL*Loader SINGLEROW keyword, SUT 5-43

index partition

dropping, SAD 13-14

moving, SAD 13-11

rebuilding, SAD 13-20

splitting, SAD 13-18

index partitions

changing physical attributes of, SQL 7-35

deallocating unused space from, SQL 7-34

dropping, SQL 7-40

marking UNUSABLE, SQL 7-146

modifying the real characteristics of, SQL 7-39

rebuilding, SQL 7-36

unusable, SQL 7-146

renaming, SQL 7-40

specifying tablespace for, SQL 7-37

splitting, SQL 7-40

index rebuilding

physical ROWIDs, MIG 11-8

index segments, SCN 1-11, SCN 4-17

index subpartitions

allocating extents for, SQL 7-40

changing physical attributes of, SQL 7-35

deallocating unused space from, SQL 7-34, SQL 7-40

marking UNUSABLE, SQL 7-40

rebuilding, SQL 7-36

renaming, SQL 7-40

specifying tablespace for, SQL 7-37

Index Unusable state

indexes left in Index Unusable state, SUT 8-11

index, cursor FOR loop, PLS 5-13

INDEX_ASC hint, SQL 2-59, STU 7-46

INDEX_COMBINE hint, SQL 2-59, STU 6-7, STU 6-16

INDEX_DESC hint, SQL 2-59, STU 7-46, STU 7-47

INDEX_FFS hint, SCN 23-36, SQL 2-59, STU 6-9, STU 7-48, STU 11-3

INDEX_HISTOGRAM view, SRF 2-172

INDEX_JOIN hint, SCN 23-36

INDEX_STATS view, SRF 2-172

index-by table

versus nested table, PLS 4-3

indexed clusters

creating, SQL 7-239

INDEXES

Export parameter, SUT 1-21

Import parameter, SUT 2-25

indexes, SCN 1-26, SCN 10-21

adding partition, SAD 13-12

allocating new extents for, SQL 7-34

altering, SAD 16-13

analyzing statistics, SAD 20-3

application-specific, SQL 7-290

ascending, SQL 7-281

auditing partitions, SCN 11-63

avoiding the use of, STU 6-7

B*-tree structure of, SCN 10-27

based on indextypes, SQL 7-285

bitmap, MIG 6-3, STU 6-13, STU 6-16, STU 6-18, STU 11-7

bitmap indexes, SCN 10-32, SCN 10-36

nulls and, SCN 10-8

parallel query and DML, SCN 10-33

bitmapped, SQL 7-279

branch blocks, SCN 10-28

building

using an existing index, SCN 10-22

building online, GTK 2-41

cardinality, SCN 10-33

changing attributes of, SQL 7-35

choosing columns for, STU 6-4

cluster, SCN 10-50, SQL 7-279

altering, SAD 17-9

cannot be partitioned, SCN 11-2

contrasted with table, SCN 10-50

creating, SAD 17-6

dropping, SAD 17-10, SCN 10-50

managing, SAD 17-1

scans of, SCN 23-41

collecting statistics on, SQL 7-38, SQL 7-186

compatibility, MIG 8-10

composite, SCN 10-22, STU 6-5

scans of, SCN 23-42

on composite-partitioned tables, SQL 7-285

concatenated, SCN 10-22

correct tables and columns, SAD 16-8

creating, ADG 6 - 5, SQL 7-277

after inserting table data, SAD 16-3

explicitly, SAD 16-8

unrecoverably, SAD 16-5

creating in parallel, STU 27-20

creating manually, SUT 2-26

deallocating unused space from, SQL 7-34

defragment using COALESCE, GTK 2-42

descending, GTK 2-25, SQL 7-281

and query rewrite, SQL 7-281

as function-based indexes, SQL 7-281

described, SCN 1-26, SCN 10-21

design, STU 2-9

direct path load

left in direct load state, SUT 8-11

disabling and dropping constraints and, SAD 16-7

disassociating statistics types from, SQL 7-454

domain, SCN 10-42, SQL 7-277, SQL 7-285, SQL 7-290

dropping, MIG 12-13

domain indexes

extensible optimization, SCN 22-16

user-defined statistics, SCN 22-17

domain, using, STU 6-23

dropped tables and, ADG 3 - 10, SAD 14-12

dropping, ADG 6 - 6, SAD 16-15

SQL*Loader, SUT 8-20

dropping before continuing a direct path load, SUT 5-34

dropping index partitions of, SQL 7-454

enforcing integrity constraints, SCN 28-10, SCN 28-12

enforcing uniqueness, STU 6-10

ensuring the use of, STU 6-6

estimating size, SAD 16-5

example, STU 4-8

examples, SQL 7-286

exporting, SUT 1-21

extensible, SCN 10-42

extensible indexing, GTK 2-31

extent allocation for, SAD 16-6

fast full scan, STU 6-8, STU 11-3

fast full scans of, SCN 23-36

FREELISTS option, SRF 1-28

function-based, ADG 6 - 6, GTK 2-24, SCN 10-24, SQL 7-277, STU 6-12

creating, SQL 7-280

dependencies, SCN 10-26, SCN 21-7, SCN 21-9

DETERMINISTIC functions, SCN 21-8

DISABLED, SCN 21-8

dropping, MIG 12-13

optimization with, SCN 10-25

privileges, SCN 10-26, SCN 21-8

global, STU 26-74

global partitioned indexes, SCN 11-32

managing partitions, SCN 11-33, SCN 11-60

globally partitioned, SQL 7-283, SQL 7-284

granting

system privileges on, SQL 7-496

guidelines, ADG 6 - 3

guidelines for managing, SAD 16-2

on hash-partitioned tables, SQL 7-284

importing, SUT 2-25

index joins, SCN 23-36, SCN 23-49

index unusable (IU), SCN 11-61

index-creation commands

Import, SUT 2-26

index-organized tables, SCN 10-36

logical rowids, SCN 10-39, SCN 12-20

secondary indexes, SCN 10-39

INITRANS for, SAD 16-4

internal structure of, SCN 10-27

key compression, SCN 10-29

key compression of, SQL 7-37, SQL 7-282

keys and, SCN 10-23

primary key constraints, SCN 28-12

unique key constraints, SCN 28-10

leaf blocks, SCN 10-28

left direct load state

SQL*Loader, SUT 8-17

limiting per table, SAD 16-3

local, STU 26-74

local indexes, SCN 11-29, SCN 11-59

building partitions in parallel, SCN 11-30

locally partitioned, SQL 7-284

location of, SCN 10-26

logging attributes of, SQL 7-282

logging rebuild operations on, SQL 7-38

LONG RAW datatypes prohibit, SCN 12-15

managing, SAD 16-1, SAD 16-15

managing partitions, SCN 11-59

marking as UNUSABLE, SQL 7-39

MAXTRANS for, SAD 16-4

merging contents of index blocks, SQL 7-39

modifying values of, STU 6-5

monitoring space use of, SAD 16-14

multiple column

SQL*Loader, SUT 8-17

no-logging mode, SCN 25-7

non-unique, STU 6-10

nonunique, SCN 10-22

nulls and, SCN 10-8, SCN 10-24, SCN 10-35

on attribute of object column, SCN 14-6

on complex data types, SCN 10-42

on REFs, SCN 14-6

online, SQL 7-283

optimization and, SCN 23-10

order of columns, ADG 6 - 4

overview of, SAD 16-2, SCN 1-26, SCN 10-21

parallel, STU 11-3

parallel creation, STU 27-20, STU 27-21

parallel DDL storage, SCN 26-33

parallel index scans, SCN 26-5

parallel local, STU 27-20

parallel queries and DML on, SQL 7-35

parallelizing creation of, SQL 7-286

parallelizing index creation, SAD 16-5

partition pruning, SCN 11-4

partitioned, NLS 4-8, SQL 2-64, SQL 7-277

user-defined, SQL 7-283

partitioned tables, SCN 10-36

partitioned tables and, REP A-4

partitioning, STU 26-46

partitioning guidelines, SCN 11-36

partitions, SCN 11-2, SCN 11-29

adding new, SQL 7-40

PCTFREE for, SAD 16-4

PCTUSED for, SAD 16-4

performance and, SCN 10-22

physical attributes of, SQL 7-281

placement on disk, STU 20-22

presorting data, SUT 4-25

SQL*Loader, SUT 8-16

privileges, ADG 6 - 5

for altering, SAD 16-13

for dropping, SAD 16-15

privileges for partitions, SCN 11-62

range scans, SCN 23-35

on range-partitioned tables, SQL 7-284

rebuild partition, SCN 11-60

rebuilding, SQL 7-36, STU 6-9

rebuilding while online, SQL 7-38

rebuilt after direct-load INSERT, SCN 25-8

recreating, STU 6-9

removing from the database, SQL 7-454

renaming, SQL 7-39

reverse, SQL 7-37, SQL 7-282

reverse key indexes, SCN 10-31

rowids and, SCN 10-28

scans of, SCN 23-35

bounded range, SCN 23-44

cluster key, SCN 23-41

composite, SCN 23-42

MAX or MIN, SCN 23-46

ORDER BY, SCN 23-47

restrictions, SCN 23-48

single-column, SCN 23-42

unbounded range, SCN 23-45

secondary for index-organized tables, GTK 2-29

selectivity of, STU 6-4

separating from a table, SAD 14-6

setting storage parameters for, SAD 16-5

skipping unusable, SUT 2-28

specifying PCTFREE for, ADG 3 - 6

specifying tablespace for, SQL 7-37

SQL*Loader, SUT 5-43

SQL*Loader and, ADG 6 - 2, SAD 16-3

state after discontinued load, SUT 5-34

statement conversion and, SCN 23-10

statistics on, SQL 7-283

statistics, gathering, STU 7-9

storage characteristics of, SQL 7-281, SQL 7-575

STORAGE clause, STU 27-21

storage format of, SCN 10-26

storage parameters, SAD 12-10

tablespace containing, SQL 7-282

tablespace for, SAD 16-4

temporary segments and, ADG 6 - 2, SAD 16-3

unique, SCN 10-22, SQL 7-278, SUT 2-25

unique scans, SCN 23-35

unsorted, SQL 7-282

user-defined types, SCN 14-6

using to improve performance, PC_ C-6

validating structure, SAD 20-8

validating structure of, SQL 7-191

when to create, ADG 6 - 2, STU 6-2

when used with views, SCN 10-14