Enterprise Edition Home |
Express Edition Home |
Previous Page
Special characters
Numerics
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Special characters
Numerics
A
B
C
- Cache
- Cardinality
- Case studies, extended
(1), (2)
- Central processing unit
- CHAR data type
- Checking indexes
- Checkpoint
- Chunk
- CKPTINTVL configuration parameter
(1), (2)
- Class name, virtual processors
- CLEANERS configuration parameter
(1), (2)
- CLOB data type
(1), (2)
- See also Smart large object.
- Clustered index
(1), (2)
- Clustering
- Code, sample, conventions for
- Code set
- Collection
- Collection-derived table
- Columns
- Command
- Command-line conventions
- Commands
- COMMIT WORK statement
- Committed Read isolation level
- Complex query, example of
- Compliance
- Composite index
(1), (2)
- Concurrency
- Configuration
- Configuration parameter
- ADTERR
- ADTMODE
- AFF_NPROCS
- AFF_SPROC
- affecting
- auditing
- backup and restore
- checkpoints
- connections
- CPU
- critical data
- data dictionary
(1), (2)
- data distributions
(1), (2), (3), (4)
- data replication
- ipcshm connection
(1), (2), (3)
- logging I/O
- logical log
- memory
- multiple connections
- network free buffer
- ON-Bar
- page cleaning
- physical log
- poll threads
(1), (2), (3), (4)
- recovery
- root dbspace
- sequential I/O
- SQL statement cache
(1), (2), (3)
- SQL statement cache cleaning
(1), (2), (3)
- SQL statement cache hits
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15)
- SQL statement cache memory
(1), (2), (3), (4)
- SQL statement cache pools
(1), (2)
- SQL statement cache size
(1), (2), (3), (4), (5)
- SQL statement memory limit
- UDR cache buckets
(1), (2)
- UDR cache entries
(1), (2)
- AUDITPATH
- AUDITSIZE
- BAR_IDLE_TIMEOUT
- BAR_MAX_BACKUP
- BAR_NB_XPORT_COUNT
- BAR_PROGRESS_FREQ
- BAR_XFER_BUF_SIZE
- BUFFERPOOL
(1), (2)
- CKPTINTVL
(1), (2)
- CLEANERS
(1), (2)
- controlling PDQ resources
- CPU, and
- DATASKIP
- DBSPACETEMP
(1), (2), (3), (4), (5), (6), (7), (8)
- DD_HASHMAX
- DD_HASHSIZE
(1), (2)
- DEADLOCK_TIMEOUT
- DEF_TABLE_LOCKMODE
(1), (2)
- DIRECTIVES
(1), (2)
- DRAUTO
- DRINTERVAL
- DRLOSTFOUND
- DRTIMEOUT
- DS_HASHSIZE
(1), (2), (3)
- DS_MAX_QUERIES
- DS_MAX_SCANS
(1), (2), (3), (4)
- DS_POOLSIZE
(1), (2)
- DS_TOTAL_MEMORY
(1), (2), (3), (4), (5)
- FAST_RESTART_CKPT_FUZZYLOG
- FAST_RESTART_PHYSLOG
- FILLFACTOR
- INFORMIXOPCACHE
- LOCKBUFF
- LOCKS
(1), (2), (3), (4)
- LOGBUFF
(1), (2), (3), (4)
- LOGFILES
- LOGSIZE
(1), (2), (3)
- LTAPEBLK
- LTAPEDEV
- LTAPESIZE
- LTXEHWM
- LTXHWM
- MAX_PDQPRIORITY
(1), (2), (3), (4), (5), (6), (7), (8)
- MIRROR
- MIRROROFFSET
- MIRRORPATH
- MULTIPROCESSOR
- NETTYPE
(1), (2), (3), (4), (5), (6), (7), (8)
- NOAGE
- NUMAIOVPS
- NUMCPUVPS
- OFF_RECVRY_THREADS
- ON_RECVRY_THREADS
- ONDBSPDOWN
- ONLIDX_MAXMEM
- OPCACHEMAX
(1), (2), (3)
- OPT_GOAL
- OPTCOMPIND
(1), (2), (3), (4)
- PC_HASHSIZE
(1), (2)
- PC_POOLSIZE
(1), (2)
- PHYSBUFF
(1), (2), (3), (4)
- PHYSFILE
- PLOG_OVERFLOW_PATH
- RA_PAGES
(1), (2)
- RA_THRESHOLD
(1), (2)
- RESIDENT
(1), (2)
- ROOTNAME
- ROOTOFFSET
- ROOTPATH
- ROOTSIZE
- SBSPACENAME
(1), (2)
- SBSPACETEMP
(1), (2), (3), (4), (5), (6)
- SHMADD
(1), (2)
- SHMBASE
- SHMMAX
(1), (2)
- SHMTOTAL
(1), (2), (3)
- SHMVIRTSIZE
(1), (2)
- SINGLE_CPU_VP
- STACKSIZE
- STAGEBLOB
(1), (2), (3)
- STMT_CACHE
(1), (2), (3), (4)
- STMT_CACHE_HITS
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15)
- STMT_CACHE_NOLIMIT
(1), (2), (3), (4), (5)
- STMT_CACHE_NUMPOOL
(1), (2)
- STMT_CACHE_SIZE
(1), (2), (3), (4), (5), (6), (7), (8), (9)
- TAPEBLK
- TAPEDEV
- TAPESIZE
- TBLTBLFIRST
- TBLTBLNEXT
- VPCLASS
(1), (2), (3), (4), (5), (6), (7), (8), (9)
- CONNECT statement
(1), (2)
- Connection
- CPU
(1), (2)
- improving performance with MaxConnect
- multiplexed
(1), (2)
- specifying number of
(1), (2)
- type, ipcshm
(1), (2), (3), (4)
- type, specifying
(1), (2), (3)
- Contact information
- Contention
- Contiguous
- Conventions
- Correlated subquery
- Cost of user-defined routine
(1), (2), (3)
- Cost per transaction
- CPU
- CREATE CLUSTERED INDEX statement
(1), (2)
- CREATE FUNCTION statement
- CREATE INDEX ONLINE statement
- CREATE INDEX statement
- CREATE PROCEDURE statement
- CREATE TABLE statement
- CREATE TEMP TABLE statement
- Critical data
- Critical media
- Critical resource
- Critical section of code
- cron
- Cursor
- Stability isolation level
(1), (2)
D
- Data
- Data-collector
- Data conversion
- Data dictionary
- Data-dictionary
- Data-dictionary cache
- Data distribution
- Data-distribution cache
- Data replication
- Data type
- BLOB
- built-in, distinct, and opaque
- BYTE
(1), (2), (3), (4)
- CHAR
(1), (2), (3)
- CLOB
- effect of mismatch
- NCHAR
(1), (2)
- NVARCHAR
(1), (2), (3)
- simple large object, for
- TEXT
(1), (2), (3), (4), (5)
- VARCHAR
(1), (2), (3), (4), (5)
- Database server administrator
- DATABASE statement
(1), (2)
- DataBlade API functions, smart large objects
(1), (2), (3), (4), (5)
- DataBlade module
- DATASKIP configuration parameter
- DB-Access utility
(1), (2), (3)
- DB-Monitor utility
- dbload utility
(1), (2)
- dbschema utility
- Dbspace
- DBSPACETEMP
- DBSPACETEMP configuration parameter
(1), (2), (3), (4), (5), (6), (7)
- DBSPACETEMP environment variable
(1), (2), (3)
- DBUPSPACE environment variable
- DD_HASHMAX configuration parameter
(1), (2)
- DD_HASHSIZE configuration parameter
(1), (2)
- Deadlock
- DEADLOCK_TIMEOUT configuration parameter
- Decision-support queries
- DEF_TABLE_LOCKMODE configuration parameter
(1), (2)
- Default locale
- Demonstration databases
- Denormalizing
- Dependencies, software
- Detached index
- Dimensional tables, defined
- Directives.
- See also Optimizer directives.
- DIRECTIVES configuration parameter
(1), (2)
- Dirty Read isolation level
(1), (2)
- Disabilities, visual
- Disk
- Disk access
- Disk extent
- Disk I/O
- allocating AIO VPs
- background database server activities
- balancing
(1), (2)
- big buffers, how used for
- binding AIO VPs
- blobspace data and
- buffered in shared memory
- BUFFERPOOL configuration parameter
- contention
- effect of UNIX configuration
- effect of Windows configuration
- effect on performance
- for temporary tables and sort files
- hot spots, definition of
- in query plan cost
(1), (2), (3)
- isolating critical data
- KAIO
(1), (2)
- light scans
- lightweight I/O
- log buffer size, effect of
- logical log
- mirroring, effect of
- monitoring
- nonsequential access, effect of
- query response time
- read-ahead configuration parameters
- reducing
(1), (2)
- sbspace data and
- sequential scans
- simple large objects
(1), (2)
- smart large objects
(1), (2)
- to physical log
- TPC-A benchmark
- unbuffered devices
- Disks
- Distinct data type
- DISTINCT keyword
- Distributed queries
- Distribution scheme
- Documentation, types of
- Documentation conventions
- Documentation Notes
- Documentation set of all manuals
- Dotted decimal format of syntax diagrams
- DRAUTO configuration parameter
- DRINTERVAL configuration parameter
- DRLOSTFOUND configuration parameter
- DROP INDEX ONLINE statement
- DROP INDEX statement
- Dropping indexes
- DRTIMEOUT configuration parameter
- DS_HASHSIZE configuration parameter
(1), (2), (3)
- DS_MAX_QUERIES configuration parameter
- DS_MAX_SCANS configuration parameter
(1), (2), (3)
- DS_NONPDQ_QUERY_MEM configuration parameter
(1), (2), (3)
- DS_POOLSIZE configuration parameter
(1), (2)
- DS_TOTAL_MEMORY configuration parameter
(1), (2), (3)
- DSS.
- See also Decision-support queries.
- dtcurrent() function, ESQL/C, to get current date and time
- Duplicate index keys, performance effects of
- Dynamic lock allocation
(1), (2), (3), (4)
- Dynamic log
E
- en_us.8859-1 locale
- Environment variable
- affecting
- DBSPACETEMP
(1), (2), (3), (4), (5)
- DBUPSPACE
- FET_BUF_SIZE
- IFX_DEF_TABLE_LOCKMODE
(1), (2)
- IFX_DIRECTIVES
- IFX_SESSION_MUX
- INFORMIXOPCACHE
(1), (2)
- OPT_GOAL
- OPTCOMPIND
(1), (2), (3)
- PDQPRIORITY
- PSORT_DBTEMP
- PSORT_NPROCS
(1), (2), (3), (4), (5), (6)
- STMT_CACHE
(1), (2), (3)
- Environment variables
- equal() function
- Equality expression, definition of
- Error messages
- ESQL/C
- Estimating space
- EXECUTE PROCEDURE statement
- Explicit temporary table
- Expression-based distribution scheme
- Extensibility enhancements
- Extent
- EXTENT SIZE clause
- Extents
- External optimizer directives
(1), (2)
F
- Fact table
- Fast recover
- Fast recovery
- FAST_RESTART_CKPT_FUZZYLOG configuration parameter
- FAST_RESTART_PHYSLOG configuration parameter
- Features, new
(1), (2), (3)
- FET_BUF_SIZE environment variable
- File
- File descriptors
- FILLFACTOR
- FILLFACTOR configuration parameter
- Filter
- Fixed and Known Defects File
- Flattened subquery
- Forced residency
- Foreground write
- Formula
- blobpage size
- buffer pool size
- calculating resident portion size
- connections per poll thread
- CPU utilization
- data buffer size, estimate of
- decision-support queries
- disk utilization
- DS total memory
(1), (2)
- extends, upper limit
- file descriptors
(1), (2)
- index extent size
(1), (2)
- index pages
(1), (2)
- initial stack size
- LOGSIZE
- memory grant basis
- message portion
- minimum DS memory
(1), (2)
- number of remainder pages
- operating-system shared memory
- paging delay
- partial remainder pages
- quantum of memory
(1), (2), (3)
- RA_PAGES
- RA_THRESHOLD
- resources allocated
- rows per page
- scan threads
- semaphores
- service time
- shared-memory estimate
- shared-memory increment size
- size of physical log
- sort operation, costs
- threshold for free network buffers
- Fragment
- elimination
- ID
- nonoverlapping
- overlapping
- FRAGMENT BY EXPRESSION clause
- Fragmentation
- Freeing shared memory
- Full checkpoint
- Function, ESQL/C, dtcurrent()
- Functional index
- Fuzzy checkpoint
- Fuzzy pages, monitoring
G
H
I
- IBM Informix MaxConnect
- IBM Informix Server Administrator
- Identifying overloaded disks
- IFX_DEF_TABLE_LOCKMODE environment variable
(1), (2)
- IFX_DIRECTIVES environment variable
- IFX_EXTDIRECTIVES environment variable
- IFX_NETBUF_PVTPOOL_SIZE environment variable
(1), (2)
- IFX_NETBUF_SIZE environment variable
(1), (2)
- IFX_SESSION_MUX environment variable
- IN DBSPACE clause
- In-place alter algorithm
- Index
- adding for performance
- attached index extent size
- autoindex
- B-tree cleaner to balance nodes
- checking
- choosing columns
- composite
(1), (2), (3), (4)
- cost of on NCHAR
- cost of on NVARCHAR
(1), (2)
- cost of on VARCHAR
- creating in online environment
- DataBlade module
(1), (2)
- detached index extent size
- disk space used by
(1), (2)
- distinct types
- dropping
(1), (2)
- dropping in online environment
- duplicate entries
- duplicate keys, avoiding
- effect of physical order of table rows
- effect of updating
- estimating pages
- estimating space
(1), (2)
- extent size
- filtered columns
- functional
(1), (2), (3)
- impact on delete, insert, and update operations
- key-only scan
- managing
(1), (2)
- on CHAR column
- on fact table in star schema
- opaque data types
- order-by and group-by columns
- ordering columns in composite
- placement on disk
- size estimate
- snowflake or star schemas
(1), (2)
- structure of entries
- time cost
- user-defined data types
(1), (2)
- when not used by optimizer
(1), (2), (3)
- when replaced by join plans
- when to rebuild
- Indexes
- Industry standards, compliance with
- Informix Dynamic Server documentation set
- INFORMIXDIR/bin directory
- INFORMIXOPCACHE environment variable
(1), (2)
- Inner table
- Input-output (I/O)
(1), (2), (3)
- See also Disk I/O., Disk I/O., Disk I/O.
- INSERT cursor
- Installation Guides
- INTO TEMP clause of the SELECT statement
(1), (2), (3), (4), (5)
- iostat command
- ipcshm connection
(1), (2)
- ISO 8859-1 code set
- Isolating tables
- Isolation level
- ANSI Repeatable Read
- ANSI Serializable
- Committed Read
(1), (2)
- Cursor Stability
(1), (2)
- Dirty Read
(1), (2), (3)
- effect on concurrency
- effect on joins
- light scans
- monitoring
(1), (2), (3), (4)
- Repeatable Read
(1), (2)
- Repeatable Read and OPTCOMPIND
(1), (2), (3)
- SET ISOLATION statement
J
- Join
- avoiding
- column for composite index
- directives
- effect of large join on optimization
- hash join
- hash join, when used
- methods
(1), (2)
- nested-loop join
(1), (2)
- order
(1), (2), (3), (4), (5), (6)
- outer
- parallel execution
- plan
- defined
- different types
- directive precedence
- directives
(1), (2)
- effects of OPTCOMPIND
- hash
(1), (2), (3), (4), (5)
- hash, in directives
(1), (2)
- isolation level effect
- nested-loop
(1), (2), (3), (4)
- OPTCOMPIND
- optimizer choosing
- replacing index use
- selected by optimizer
- star
- subquery
- running UPDATE STATISTICS on columns
- semi join
- SET EXPLAIN output
- subquery
- subquery flattening
- thread
- three-way
- view
- with column filters
- Join and sort, reducing impact
K
L
- Latch
- Latency, disk I/O
- Leaf index pages, defined
- Least recently used
- lessthan() function
- lessthanorequal() function
- Light scans
- Lightweight I/O
- LIKE test
- LO_DIRTY_READ flag
- LO_NOBUFFER flag, specifying lightweight I/O
- LO_TEMP flag
- LOAD and UNLOAD statements
(1), (2), (3), (4), (5)
- Locale
- Locating simple large objects
- Lock
- Lock table
- specifying initial size
(1), (2)
- LOCKBUFF configuration parameter
- LOCKS configuration parameter
(1), (2), (3), (4)
- LOGBUFF configuration parameter
(1), (2), (3), (4)
- LOGFILES configuration parameter
- Logging
- Logical log
- LOGSSIZE configuration parameter
- Long transaction
- Loosely-coupled mode
- LRU.
- See also Least recently used.
- lru_max_dirty value
- lru_min_dirty value
- LRU queues
- lrus value
- LTAPEBLK configuration parameter
- LTAPEDEV configuration parameter
- LTAPESIZE configuration parameter
- LTXEHWM configuration parameter
- LTXHWM configuration parameter
M
- Machine notes
- Managing extents
- Materialized view
- MAX_PDQPRIORITY configuration parameter
(1), (2)
- Memory
- activity costs
- cache
- configuration parameters
- data-replication buffers
- estimate for sorting
- hash join
- hash joins
- increase by logging
- limited by
- monitoring by session
- monitoring MGM allocation
- network buffer pool
(1), (2), (3)
- opclass cache
- PDQ priority effect
(1), (2)
- private network free-buffer pool
(1), (2)
- quantum allocated by MGM
(1), (2), (3), (4), (5)
- sort
(1), (2)
- SPL routines
- SQL statement cache
(1), (2)
- SSC limit
(1), (2), (3)
- SSC size
(1), (2)
- typename
- UDR cache
(1), (2), (3)
- UNIX configuration parameters
- utilizing
- Windows parameters
- Memory Grant Manager
- Memory-management system
- Messages
- Metadata
- Metric classes, onperf
- Microsoft Transaction Server
- MIRROR configuration parameter
(1), (2)
- Mirroring
- MIRROROFFSET configuration parameter
- MIRRORPATH configuration parameter
- MODIFY NEXT SIZE clause
(1), (2)
- Monitoring
- aggregate cache
- AIO virtual processors
- buffer pool
- buffers
- checkpoints
- CPU utilization
(1), (2)
- data-dictionary cache
- data-distribution cache
- deadlocks
- disk utilization
(1), (2), (3)
- estimated number of rows
- foreground writes
- fragments
- fuzzy pages
- global transactions
(1), (2)
- I/O queues for AIO VPs
- isolation level
(1), (2)
- latch waits
(1), (2), (3), (4)
- light scans
(1), (2), (3)
- locks
(1), (2), (3), (4), (5), (6)
- locks used by sessions
- logical-log files
- longspins
- LRU queues
(1), (2)
- memory per thread
- memory pools
- memory usage
- memory utilization
- MGM resources
- network buffer size
- network buffers
- number of connections
- number of users
- OPCACHEMAX
- optical cache
- PDQ threads
(1), (2)
- resources for a session
- sbspace
(1), (2)
- sbspace metadata size
(1), (2)
- sbspaces
- session memory
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22), (23), (24), (25), (26), (27), (28), (29), (30), (31)
- sessions
(1), (2)
- smart large objects
- sort files
- SPL routine cache
(1), (2)
- SQL statement cache
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13)
- SSC memory pools
- STAGEBLOB blobspace
- statement cache
(1), (2)
- statement memory
(1), (2), (3)
- temporary dbspaces
- threads
- throughput
- transaction
(1), (2), (3)
- transactions
- UDR cache
(1), (2)
- user sessions
- user threads
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10)
- virtual portion
- virtual processors
(1), (2), (3), (4), (5)
- Monitoring database server
- Monitoring tools
- Motif window manager
(1), (2), (3)
- Multiple residency
- Multiplexed connection
- MULTIPROCESSOR configuration parameter
- Mutex
- mwm window manager, required for onperf
N
O
- Obtaining
(1), (2), (3)
- OFF_RECVRY_THREADS configuration parameter
- OLTP applications
- OLTP query
- ON-Bar
- ON-Monitor utility
(1), (2)
- ON_RECVRY_THREADS configuration parameter
- onaudit utility
- oncheck utility
- -pB option
(1), (2)
- -pe option
(1), (2), (3), (4)
- -pk option
- -pK option
- -pl option
- -pL option
- -pp option
- -pP option
- -pr option
(1), (2)
- -ps option
(1), (2)
- -pS option
(1), (2)
- -pt option
(1), (2)
- -pT option
(1), (2), (3)
- blobpage information
- checking index pages
- defined
- displaying
- index sizing
- monitoring
- obtaining information
- outstanding in-place alters
- physical layout of chunk
- ONDBSPDOWN configuration parameter
- ONLIDX_MAXMEM configuration parameter
(1), (2)
- Online help
- Online manuals
- Online notes
(1), (2)
- onload and onunload utilities
(1), (2), (3), (4)
- onlog utility
(1), (2)
- onmode utility
- onparams utility
(1), (2)
- onperf utility
- onspaces utility
- onstat
- onstat utility
- -- option
- -a option
- -b option
(1), (2), (3), (4), (5), (6)
- -B option
- -d option
(1), (2), (3), (4)
- -F option
(1), (2)
- -g act option
(1), (2)
- -g afr option
- -g ath option
(1), (2), (3), (4), (5)
- -g cac option
- -g cac stmt option
- -g dic option
(1), (2), (3), (4), (5)
- -g dsc option
(1), (2)
- -g glo option
- -g iof option
(1), (2)
- -g iog option
(1), (2)
- -g ioq option
(1), (2), (3), (4)
- -g iov option
(1), (2)
- -g mem option
(1), (2), (3), (4), (5)
- -g mgm option
(1), (2), (3)
- -g ntd option
- -g ntf option
- -g ntm option
- -g ntu option
(1), (2), (3)
- -g option
- -g ppf option
- -g prc option
(1), (2)
- -g qst option
- -g rea option
(1), (2), (3), (4)
- -g sch option
- -g scn to monitor light scans
(1), (2)
- -g seg option
(1), (2), (3)
- -g ses option
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17)
- -g sle option
- -g smb option
- -g smb s option
- -g spi option
(1), (2), (3)
- -g sql option
(1), (2), (3), (4), (5)
- -g sql session-id option
(1), (2)
- -g ssc
(1), (2), (3)
- -g ssc all
(1), (2), (3)
- -g ssc option
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11)
- -g ssc output description
- -g ssc pool option
(1), (2), (3)
- -g stm option
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18)
- -g sts option
(1), (2)
- -g tpf option
- -g wai option
- -g wst option
- -k option
(1), (2), (3), (4), (5), (6)
- -l option
- -m option
- -O option
- -p option
(1), (2), (3), (4), (5), (6)
- -R option
(1), (2)
- -s option
- -t option
- -u option
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19)
- -x option
(1), (2)
- defined
- monitoring
- ontape utility
(1), (2)
- Opaque data type
- OPCACHEMAX configuration parameter
- Operating system
- Operator class
- OPT_GOAL configuration parameter
- OPT_GOAL environment variable
- OPTCOMPIND
- OPTCOMPIND configuration parameter
(1), (2), (3)
- OPTCOMPIND environment variable
(1), (2), (3)
- Optical Subsystem
- Optimization goal
- Optimization level
- Optimizer
- Optimizer directives
- ALL_ROWS
- altering query plan
- AVOID_EXECUTE
- AVOID_FULL
(1), (2)
- AVOID_HASH
- AVOID_INDEX
- AVOID_NL
(1), (2)
- configuration parameter
- effect on views
(1), (2)
- EXPLAIN
(1), (2), (3)
- EXPLAIN AVOID_EXECUTE
- external directives
(1), (2)
- FIRST_ROWS
(1), (2)
- FULL
- guidelines
(1), (2)
- INDEX
- influencing access plan
- join order
(1), (2)
- join plan
(1), (2)
- OPTCOMPIND
- ORDERED
(1), (2), (3), (4)
- purpose
(1), (2)
- SPL routines
- table scan
- types
- USE_HASH
- USE_NL
- ORDER BY clause
(1), (2)
- Ordered merge
- Outer join
- Outer table
- Output description
- Outstanding in-place alters
- Overloaded disks
P
- Page
- Page buffer
- Page size
(1), (2), (3)
- Paging
- Parallel
- Parallel database queries
- Parallel processing
- Parallel UDRs
- Partitioning
- Partitions
- PC_HASHSIZE configuration parameter
(1), (2)
- PC_POOLSIZE configuration parameter
(1), (2)
- PDQ
- See also Parallel database queries.
- PDQ priority
- PDQPRIORITY
- PDQPRIORITY configuration parameter
- PDQPRIORITY environment variable
- Peak loads
- perfmon.exe
- Performance
- Performance problems
- PHYSBUFF configuration parameter
(1), (2), (3), (4)
- PHYSFILE configuration parameter
- Physical log
- Playback process
- PLOG_OVERFLOW_PATH configuration parameter
- Poll thread
- Printed manuals
- Priority
- Probe table, directives
(1), (2)
- PSORT_DBTEMP environment variable
(1), (2)
- PSORT_NPROCS environment variable
(1), (2), (3), (4)
Q
- Quantum, of memory
(1), (2), (3), (4), (5), (6), (7), (8)
- Queries
- Query optimizer
- Query plan
- all rows
- altering with directives
(1), (2), (3), (4)
- autoindex path
- avoid query execution
- chosen by optimizer
(1), (2)
- collection-derived table
- disk accesses
- displaying
(1), (2)
- first-row
- fragment elimination
(1), (2)
- indexes
- join order
- pseudocode
(1), (2)
- restrictive filters
- row access cost
- time costs
(1), (2), (3), (4)
- Query-tree tool, onperf
R
- R-tree index
- RA_PAGES configuration parameter
(1), (2)
- RA_THRESHOLD configuration parameter
(1), (2)
- Range expression, defined
- Raw devices
- See also Unbuffered devices.
- Read-ahead
- Read cache rate
- Recent history
- Reclaiming empty extent space
- Redundant data, introduced for performance
- Redundant pairs, defined
- Regular expression, effect on performance
- Relational model
- Release Notes
- Remainder pages
- Remote database
- RENAME statement
- Repeatable Read isolation level
(1), (2), (3)
- Residency
- RESIDENT configuration parameter
(1), (2)
- Resident portion of shared memory
- Resizing table to reclaim empty space
- Resource utilization
- Resources
- Response time
- Response times
- RETURN statement
- Root dbspace
- Root index page
- ROOTNAME configuration parameter
- ROOTOFFSET configuration parameter
- ROOTPATH configuration parameter
- ROOTSIZE configuration parameter
- Round-robin distribution scheme
(1), (2)
- Round-robin fragmentation, smart large objects
- Row access cost
- Row pointer
S
- Sample-code conventions
- sar command
(1), (2)
- Saturated disks
- sbspace
- sbspace extents
- SBSPACENAME
- SBSPACENAME configuration parameter
(1), (2), (3), (4)
- SBSPACETEMP
- SBSPACETEMP configuration parameter
(1), (2), (3), (4), (5), (6)
- Scan
- Scans
- Scheduling facility, cron
(1), (2)
- Screen reader
- Secondary access method
- SELECT statement
- Selective filter
- Selectivity
- Semaphores
- Semi-join, defined
- SEMMNI UNIX configuration parameter
(1), (2)
- SEMMNS UNIX configuration parameter
- SEMMSL UNIX configuration parameter
- Sequential
- Service time formula
- Session
- monitoring
(1), (2), (3), (4), (5)
- monitoring memory
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16)
- setting optimization goal
- SET DATASKIP statement
- SET ENVIRONMENT OPTCOMPIND
(1), (2)
- SET ENVIRONMENT OPTCOMPIND command
- SET EXPLAIN
- SET ISOLATION statement
(1), (2)
- SET LOCK MODE statement
(1), (2), (3), (4), (5), (6), (7)
- SET LOG statement
- SET OPTIMIZATION statement
- SET PDQPRIORITY statement
- SET STATEMENT CACHE statement
(1), (2), (3), (4)
- SET TRANSACTION statement
- Shared memory
- SHMADD configuration parameter
(1), (2)
- SHMBASE configuration parameter
- SHMMAX configuration parameter
(1), (2), (3)
- SHMMNI operating-system configuration parameter
- SHMSEG operating-system configuration parameter
- SHMSIZE operating-system configuration parameter
- SHMTOTAL configuration parameter
(1), (2), (3)
- SHMVIRTSIZE configuration parameter
(1), (2)
- Short rows, reducing disk I/O
- Simple large object
- SINGLE_CPU_VP configuration parameter
- Smart large object
- ALTER TABLE
- buffer pool
(1), (2), (3), (4)
- buffer pool usage
(1), (2)
- buffering recommendation
- changing characteristics
- CREATE TABLE statement
- DataBlade API functions
(1), (2), (3), (4), (5)
- disk I/O
- ESQL/C functions
(1), (2), (3), (4), (5)
- estimated size
(1), (2)
- estimating space
- extent size
(1), (2), (3), (4), (5)
- fragmentation
(1), (2), (3)
- I/O operations
(1), (2)
- I/O performance
(1), (2), (3), (4), (5), (6)
- last-access time
(1), (2)
- lightweight I/O
(1), (2), (3)
- lock mode
(1), (2)
- logging status
(1), (2)
- logical-log size
- minimum extent size
(1), (2)
- mirroring chunks
- monitoring
- next-extent size
(1), (2)
- sbspace
- sbspace name
(1), (2)
- setting isolation levels
- specifying characteristics
- specifying size
(1), (2), (3), (4)
- storage characteristics
- SMI table
- Snowflake schema
- Software dependencies
- Sort memory
- Sorting
- SPL
- See also Stored Procedure Language.
- SPL routine
- sqexplain.out file
(1), (2), (3)
- sqexpln.out file
- SQL code
- SQL new features
- SQL statement cache
- cleaning
(1), (2), (3)
- defined
- effect on prepared statements
- effect on SHMVIRTSIZE
- exact match
- flushing
- hits
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15)
- host variables
- memory
- memory limit
(1), (2), (3), (4)
- memory size
(1), (2)
- monitoring
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15)
- monitoring dropped entries
(1), (2)
- monitoring pools
(1), (2), (3), (4)
- monitoring session memory
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13)
- monitoring size
(1), (2)
- monitoring statement memory
(1), (2), (3)
- number of pools
(1), (2)
- performance benefits
(1), (2)
- response times
- size
(1), (2), (3), (4)
- specifying
(1), (2)
- STMT_CACHE configuration parameter
(1), (2), (3), (4)
- STMT_CACHE environment variable
(1), (2), (3)
- STMT_CACHE_HITS configuration parameter
- STMT_CACHE_SIZE configuration parameter
(1), (2)
- when to use
- SQLCODE field of SQL Communications Area
- sqlhosts file
- sqlhosts file or registry
- SQLWARN array
- Stack
- STACKSIZE configuration parameter
- STAGEBLOB configuration parameter
- Staging area
- Star join, defined
- Star schema
- Statement cache.
- See also SQL Statement cache.
- Status tool
(1), (2)
- STMT_CACHE configuration parameter
(1), (2)
- STMT_CACHE environment variable
(1), (2), (3)
- STMT_CACHE_HITS configuration parameter
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15)
- STMT_CACHE_NOLIMIT configuration parameter
(1), (2), (3), (4), (5)
- STMT_CACHE_NUMPOOL configuration parameter
(1), (2)
- STMT_CACHE_SIZE configuration parameter
(1), (2), (3), (4), (5), (6), (7), (8), (9)
- Storage characteristics
- Storage space
- Storage statistics
- Stored Procedure Language
(1), (2)
- stores_demo database
- Strategy function
- Strings
- Structured Query Language
- ALTER FRAGMENT statement
(1), (2)
- ALTER FUNCTION statement, parallel UDRs
- ALTER INDEX statement
(1), (2), (3), (4)
- ALTER TABLE statement
(1), (2)
- COMMIT WORK statement
- CONNECT statement
(1), (2)
- CREATE CLUSTERED INDEX statement
- CREATE FUNCTION statement
- CREATE INDEX statement
- CREATE PROCEDURE statement, SQL optimization
- CREATE TABLE statement
- CREATE TEMP TABLE statement
- DATABASE statement
(1), (2)
- EXECUTE PROCEDURE statement
- EXTENT SIZE clause
- FRAGMENT BY EXPRESSION clause
- GROUP BY clause
- IN DBSPACE clause
- INSERT statement
- LOAD and UNLOAD statements
(1), (2), (3), (4), (5)
- MODIFY NEXT SIZE clause
(1), (2)
- NEXT SIZE clause
- optimizer directives
- ORDER BY clause
- RENAME statement
- SELECT statement
- SET DATASKIP statement
- SET EXPLAIN statement
(1), (2)
- SET EXPLAIN statement directives
- SET ISOLATION statement
- SET LOCK MODE statement
(1), (2), (3), (4), (5), (6), (7)
- SET OPTIMIZATION statement
(1), (2), (3)
- SET PDQPRIORITY statement
- SET STATEMENT CACHE
(1), (2), (3), (4)
- SET TRANSACTION statement
- TO CLUSTER clause
(1), (2), (3)
- UPDATE STATISTICS statement
(1), (2), (3)
- and directives
(1), (2)
- creating data distributions
(1), (2)
- data distributions
- effect of PDQ
- guidelines to run
(1), (2)
- HIGH mode
(1), (2), (3), (4), (5), (6)
- LOW mode
(1), (2), (3), (4), (5), (6), (7), (8), (9)
- MEDIUM mode
(1), (2)
- multiple column distributions
- on join columns
- on user-defined data columns
- optimizing SPL routines
- query optimization
- reoptimizing SPL routines
- updating system catalog
(1), (2)
- user-defined data
- WHERE clause
(1), (2), (3)
- Subquery
- superstores_demo database
- Support function
- Swap device
- Swap space
(1), (2)
- Swapping, memory
(1), (2)
- Symbol table
- Syntax diagrams
- Syntax segment
- sysmaster database
- sysprofile table
- System catalog tables
- System-monitoring interface
(1), (2), (3), (4)
- System requirements
- System resources, measuring utilization
T
- Table
- Table hierarchy
- Table scan
- TAPEBLK configuration parameter
- TAPEDEV configuration parameter
- TAPESIZE configuration parameter
- Tblspace
- TBLTBLFIRST configuration parameter
- TBLTBLNEXT configuration parameter
- TCP connections
(1), (2)
- TCP/IP buffers
- TEMP or TMP user environment variable
- TEMP TABLE clause of the CREATE TABLE statement
(1), (2), (3)
- Temporary dbspace
- Temporary sbspace
- Temporary smart large object
- Temporary table
- TEXT data type
(1), (2)
- See also Simple large object.
- Thrashing, defined
- Thread
- control blocks
- DS_MAX_SCANS configuration parameter
- MAX_PDQPRIORITY
- monitoring
(1), (2), (3), (4), (5), (6), (7), (8)
- page-cleaner
- primary
(1), (2)
- secondary
(1), (2)
- sqlexec
(1), (2), (3)
- Thread-safe
- Throughput
- Tightly coupled
(1), (2), (3)
- Time
- time command
- Timing
- TO CLUSTER
- TOC Notes
- TPC-A, TPC-B, TPC-C, and TPC-D benchmarks
- Transaction
- cost
- loosely coupled
(1), (2)
- monitoring
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13)
- monitoring global transactions
(1), (2)
- rate
- rollback
- tightly-coupled mode
(1), (2), (3)
- Transaction Processing Performance Council
- Transaction throughput, effects of MAX_PDQPRIORITY
- Trigger
- Typographical conventions
U
- UDR cache
- Unbuffered devices
- Unbuffered logging
- UNIX
- Update cursor
- UPDATE STATISTICS statement
- creating data distributions
(1), (2)
- data distributions
- directives
(1), (2)
- effect of PDQ
- effect on virtual portion of memory
- generating with ISA
- guidelines to run
(1), (2)
- HIGH mode
(1), (2), (3), (4), (5), (6), (7)
- improving ALTER FRAGMENT ATTACH performance
(1), (2)
- LOW mode
(1), (2), (3), (4), (5), (6), (7), (8), (9)
- MEDIUM mode
(1), (2)
- multiple column distributions
- on join columns
- on user-defined data columns
- optimizing SPL routines
- providing information for query optimization
- query optimization
- reoptimizing SPL routines
- updating system catalog
(1), (2)
- user-defined data
(1), (2)
- using on very large databases
- Usability enhancements
- User-defined aggregate
- User-defined data type
- User-defined index
- User-defined routine
- User-defined routine cache
- User-defined selectivity function
- User-defined statistics
- Users, types of
- USING clause, CREATE INDEX statement
- Utilities
- DB-Access
- dbload
(1), (2)
- dbschema
(1), (2), (3), (4), (5), (6)
- ISA
(1), (2)
- monitoring performance
- ON-Monitor
(1), (2), (3)
- onaudit
- oncheck
- onload and onunload
(1), (2), (3), (4)
- onlog
(1), (2)
- onmode
- onmode and PDQ
- onparams
(1), (2)
- onperf
- onspaces
- onstat
- -- option
- -a option
- -b option
(1), (2), (3), (4), (5), (6)
- -B option
- -d option
(1), (2), (3), (4)
- -F option
- -g act option
(1), (2)
- -g afr option
- -g ath option
(1), (2), (3), (4), (5)
- -g cac option
(1), (2)
- -g cac stmt option
- -g dic option
(1), (2)
- -g dsc option
(1), (2)
- -g glo option
- -g iof option
(1), (2)
- -g iog option
(1), (2)
- -g ioq option
(1), (2), (3), (4)
- -g iov option
(1), (2)
- -g lsc option
- -g mem option
(1), (2), (3), (4), (5)
- -g mgm option
(1), (2), (3)
- -g ntd option
- -g ntf option
- -g ntm option
- -g ntu option
(1), (2), (3)
- -g option
- -g ppf option
- -g prc option
(1), (2)
- -g qst option
- -g rea option
(1), (2), (3), (4)
- -g sch option
- -g seg option
(1), (2), (3)
- -g ses option
(1), (2), (3), (4), (5), (6), (7), (8)
- -g sle option
- -g smb option
- -g smb s option
- -g spi option
(1), (2)
- -g sql option
(1), (2)
- -g ssc all option
(1), (2), (3)
- -g ssc option
(1), (2), (3), (4)
- -g stm option
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14)
- -g sts option
(1), (2)
- -g tpf option
- -g wai option
- -g wst option
- -k option
(1), (2)
- -l option
- -m option
- -O option
- -p option
(1), (2), (3), (4), (5), (6)
- -P option
- -R option
(1), (2)
- -s option
- -u option
(1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13)
- -x option
(1), (2)
- introduced
- monitoring buffer pool
- monitoring threads per session
- ontape
(1), (2)
- Utilization
V
W
- WHERE clause
(1), (2), (3)
- Windows
- WORM.
- See also Write once read many.
- Write once read many
X
Enterprise Edition Home |
Express Edition Home |
[ Top of Page | Previous Page | Contents |
Index ]