Index

A  B  C  D  E  F  G  H  I  J  L  M  N  O  P  Q  R  S  T  U  V  W  X 

A

accent-insensitive linguistic sort, 5.5.3
access control, 4
authorizing, 4.2.1
overview, 4.2
acknowledging updates, 9.8.2
active standby pair
aging, 7.2.3.5
ADMIN privilege, 4.2.1.1, 4.2.2
administrator
privileges, 4.2.1.1
aging
active standby pair, 7.2.3.5
attributes, 7.2.3.1
foreign keys, 7.2.3.3
LRU, 7.2.3, 7.2.3.1
ON DELETE CASCADE, 7.2.3.3
parent and child tables, 7.2.3.3
performance, 7.2.3.2
replication, 7.2.3.5
restrictions, 7.2.3
tables, 7.2.3
time-based, 7.2.3, 7.2.3.2
usage-based, 7.2.3.1
ALL keyword, 4.2.3.1
system privileges, 4.2.2.2
ALL_TAB_PRIVS view, 4.2.6
ALL_USERS view, 4.1.2
allfunctions command
ttIsql utility, 6.9
-allowNetworkFiles option
ttendaemon.options file, 3.4.4
allpackages command
ttIsql utility, 6.9
allprocedures command
ttIsql utility, 6.9
ALTER ANY CACHE GROUP privilege, 4.2.5.2
ALTER ANY privilege, 4.2.2.5.1, 4.2.3.7
ALTER SESSION SQL statement, 5.7
ALTER TABLE
adding and removing columns, 7.2.1.1
and performance, 9.3.7
REFERENCES privilege, 4.2.3.6
ANY system privileges, 4.2.2.5
application
failure
use of logs and locks, 8.2
shut down, 3.3
ASCIISTR SQL function, 5.6
asynchronous checkpoints
See fuzzy checkpoints
attributes
connection, 2.2.5
data source name, 1.6.3
PermWarnThreshold, 1.10.4
setting for UNIX, 1.3.2.1
specifying, 1.3.1.3
TempWarnThreshold, 1.10.4
viewing and changing by ttIsql, 6.10
AUTO_ACKNOWLEDGE mode, 9.8.2
autocommit
performance impact, 9.5.4
autocommit command
ttIsql utility, 6.11

B

backup
database, 1.12.1, 1.12.2
full, 1.12.2.1
incremental, 1.12.2.1
stream, 1.12.2.1
types, 1.12.2.1
batch mode
ttIsql, 6.1
bitmap index, 9.3.2
when used, 7.5.1
byte semantics, 5.3

C

cache group
altering, 4.2.5.2
creation, 4.2.5.2
dropping, 4.2.5.2
granting privileges, 4.2.5
privileges, 4.2.1.2, 4.2.5.3
required privileges for AWT, 4.2.5.1
time-based aging, 7.2.3.2
CACHE_MANAGER privilege, 4.2.5.1
cachegroups command
ttIsql utility, 6.8, 6.8.2
case-insensitive linguistic sort, 5.5.3
character semantics, 5.3
character set
and replication, 5.2.4
choosing, 5.2
working with in ttIsql, 6.7
checkpoints
and performance, 9.5.3
automatic, 7.1.3
fuzzy
influences on duration, 8.7
static
CHR SQL function, 5.6
clearing command history
ttIsql, 6.6.1
client
configuring automatic failover on UNIX, 2.2.5.2.2
configuring automatic failover on Windows, 2.2.5.1.2
connection attributes
described, 2.2.3, 2.2.5
creating DSN
on UNIX, 2.2.5.2.1
on Windows, 2.2.5.1.1
performance, 9.2.1
Client DSN
creating, 2.2.5.2
creating on UNIX, 2.2.5.2.1
creating on Windows, 2.2.5.1.1
Data Source Setup dialog, 2.2.5.1.1
name, 2.2.5.1.1
CLIENT_ACKNOWLEDGE mode, 9.8.3
Client/Server
changing shared memory segment size, 3.5.5.2
communication
overview, 2.1.2
configuring, 2.2
connections across bit-levels, 2.2.2.2
connections across releases, 2.2.2.2
managing shared memory segment size, 3.5.5.1
shared memory, 3.5.5.2
TCP/IP communication, 2.1.2.1, 2.1.2.1
UNIX socket communication, 2.1.2.3, 2.1.2.3
Client/Server communication
shared memory, 3.5.5
TCP/IP, 3.5.5
close command
ttIsql utility, 6.12
cmdcache command
ttIsql utility, 6.15.2.1
coexistence of different locking levels
columns
adding, 7.2.1.1
default values, 7.2.1.3
in-line, 7.2.1.2
nullability, 7.2.1.1
command
invalidated, 10.1
invalidation, 9.3.6
command history
ttIsql, 6.6
commit behavior
Oracle, 8.1.1.2
TimesTen, 8.1.1.2
commit command
ttIsql utility, 6.11
commitdurable command
ttIsql utility, 6.11
concurrency
locking, 8.6, 9.2.3.1
types of isolation, 8.6
configuring
Client/Server, 2.2
connect
using connection string, 1.8
connect command
ttIsql utility, 6.16
Connection
setAutoCommit method, 8.1.1.1, 8.1.1.1
connection
locking, 9.2.3
locks, 9.2.2
performance overhead, 9.1.6
testing on Windows, 2.2.5.1.5
timeout interval, 9.2.2
connection attribute
connection, 2.2.3
LockLevel, 9.2.3
LogFlushMethod, 9.5.2
PermSize, 1.10, 1.10
PLSCOPE_SETTINGS, 1.6.2
PLSQL_MEMORY_ADDRESS attribute, 1.6.2
PLSQL_MEMORY_SIZE attribute, 1.6.2
PLSQL_OPTIMIZE_LEVEL, 1.6.2
TempSize, 1.10, 1.10
UID, 7.1.2
connection attributes
UNIX, 1.3.2.1
connection character set, 2.2.5.1.1, 5.4
connection string
using to connect, 1.8
ConnectionCharacterSet general connection attribute, 5.4
Connection.prepareStatement method, 10.3.1
and execution plan generation, 10.4.2
contention
lock, 9.1.9
CREATE ANY CACHE GROUP privilege, 4.2.5.2
CREATE ANY privilege, 4.2.2.5.1
CREATE ANY SYNONYM statement, 4.2.3.8
CREATE ANY TABLE privilege, 4.2.5.2
CREATE CACHE GROUP privilege, 4.2.5.2
CREATE INDEX statement, 7.5.2
CREATE OR REPLACE SYNONYM statement, 4.2.3.8, 7.7.1
CREATE privilege, 4.2.2.5.1
CREATE PUBLIC SYNONYM statement, 4.2.3.8
CREATE SESSION privilege, 4.2.2.3, 4.2.2.3
CREATE SYNONYM statement, 4.2.3.8, 7.7.1
CREATE TABLE privilege, 4.2.5.2
creating indexes
example, 7.5.2
how to do, 7.5.2
Custom setup, Windows, 1.1.1

D

daemon
control operations, 3.4.3
informational messages on Windows
listener, 3.4.1
IPv4 protocol, 3.4.1.1
listening address, 3.4.1, 3.4.1
modifying options, 3.5.1
options, 3.4
options, see ttendaemon.options file
overview, 3
starting and stopping on UNIX, 3.2
starting and stopping on Windows, 3.1
starting on UNIX, 3.2
starting on Windows, 3.1
stopping on UNIX, 3.2
stopping on Windows, 3.1
data
permanent, 1.10
temporary, 1.10
Data Manager service, 3.1
starting, 3.1
stopping, 3.1
data source
UNIX configuration files, 1.7.3
data source names, See DSN
database
accessing on a local machine, 2.1.2.3
accessing on a remote machine, 2.1.2.1
backup, 1.12.1, 1.12.1
changing size of, 1.10
components, 7.1.1, 7.1.1
connecting, 4.2.2.3, 4.2.2.3
contention, 9.1.9
copying, 1.12.1
definition, 1
getting information with ttIsql, 6.8
loading to memory, 1.9
lock contention, 9.1.9
migrating, 1.12.1, 1.12.1
owner, 7.1.2
path names, environment variables in, 1.3.2.2
permanent, 7.1.3
prefix name, 1.3.2.1
restoring, 1.12.1, 1.12.1
setting attributes for UNIX, 1.3.2.1
sizing, 9.1.2
specifying size, 9.1.2
TCP/IP Client/Server access, 2.1.2.1
temporary, 1.6.1, 7.1.3, 9.1.5
performance, 9.1.5
UID connection attribute, 7.1.2
UNIX socket Client/Server access, 2.1.2.3
user names, 7.1.2
users, 7.1.2
database character set
application, 5.2.2
client operating system, 5.2.2
languages, 5.2.1
performance, 5.2.3
DatabaseCharacterSet attribute, 5.2
database-level locks, 8.6.2, 8.6.2, 8.6.2
DBA_SYS_PRIVS view, 4.2.2, 4.2.2.1, 4.2.6
DBA_TAB_PRIVS view, 4.2.2.1, 4.2.6
DBA_USERS view, 4.1.2
DDLCommitBehavior connection attribute, 8.1.1.2
default column values, 7.2.1.3
DELETE ANY privilege, 4.2.2.5
DELETE privilege, 4.2.3.2
deleting
rows, 7.6.2
Windows server name, 2.2.4.1
describe command
ttIsql utility, 6.8, 6.8.1, 6.12
detail table, 7.4.1
diagnostics
SNMP traps, 1.10.4
driver
JDBC, 1.3.1.1
DRIVER attribute, 1.3.2.1
driver manager
JDBC, 1.1.2
linking with, 1.1
ODBC, 1.1
DriverManager.getConnection method, 2.2.5, 2.2.5
drop
materialized view, 7.4.2.2
materialized view log, 7.4.2.2
DROP ANY CACHE GROUP privilege, 4.2.5.2
DROP ANY privilege, 4.2.2.5.1
DROP ANY SYNONYM statement, 4.2.3.8
DROP PUBLIC SYNONYM statement, 4.2.3.8
DROP SYNONYM statement, 7.7.2
dropping
indexes, 7.5.4
tables, example, 7.2.2.2
DSN, 4.2.2.3
Client, 1.2.2, 1.2.2, 2.2.5
connection attributes, Data Manager, 1.2.3
Data Manager, 1.2.2
example, 1.6
example, Windows
finding in order of precedence, 1.5
maximum length, 1.2
naming rules, 1.2
number of server processes, 3.5.4.2
.odbc.ini file, 1.2.1
setting attributes, 1.6.3
specification, 1.7.2
system, 1.2.1
user, 1.2.1
dssize command
ttIsql utility, 6.8, 6.8.3
DUPS_OK_ACKNOWLEDGE mode, 9.8.2
durability
overview, 8.4
durable commit
performance, 9.5.2
transaction, 9.5.1

E

editline for ttIsql, 6.5
-enableIPv6 option
ttendaemon.options file, 3.4.1.1
-enablePolicyInactive option
ttendaemon.options file, 3.4.7
environment variables
in database path names, 1.3.2.2
TTISQL, 6.2
examples
creating indexes, 7.5.2
creating tables, 7.2.2.1
drop materialized view, 7.4.2.2
drop materialized view log, 7.4.2.2
dropping tables, 7.2.2.2
PLAN rows, 10.3.1.2
exec command
ttIsql utility, 6.12
execandfetch command
ttIsql utility, 6.12
EXECUTE ANY privilege, 4.2.2.5
EXECUTE privilege, 4.2.3.7
execution plan
generating, 10.1, 10.4.2
modifying, 10.4.1, 10.4.2, 10.4.3
execution plan generation
and Connection.prepareStatement, 10.4.2
explain command
ttIsql utility, 6.15.2.2
explain plan
display, 6.15.2.2

F

-facility option
ttendaemon.options file, 3.4.2
failover
configuring for client on UNIX, 2.2.5.2.2
configuring for client on Windows, 2.2.5.1.2
fetchall command
ttIsql utility, 6.12
fetchone command
ttIsql utility, 6.12
files
odbc.ini, 1.2.1, 1.7.3
.ttconnect.ini, 2.2.4.3
ttendaemon.options, 3.4, 3.4.3, 3.5.5
first connection attribute, 4.2.2.3
PLSQL_MEMORY_SIZE, 9.1.3
FLUSH ANY CACHE GROUP privilege, 4.2.5.2
FLUSH privilege, 4.2.5.3
foreign key
REFERENCES privilege, 4.2.3.6
foreign key constraint
and performance, 9.3.4
fragmentation
block-level, 1.10.3
free command
ttIsql utility, 6.12
functions
object privileges, 4.2.3.7
functions command
ttIsql utility, 6.9
fuzzy checkpoints, definition

G

GRANT ALL command, 4.2.2.2, 4.2.3.1
GRANT command, 4.2.2, 4.2.3

H

hash index, 9.3.2
hash indexes
definition, 7.5.1
overview, 7.5.1
sizing, 9.3.3
when used, 7.5.1
host binds
using ttIsql, 6.12
HP-UX ccNUMA systems
shared memory, 3.4.6

I

index
aging performance, 7.2.3.2
automatic creation, 7.2.1.5
explicit creation, 7.2.1.5
INDEX privilege, 4.2.3.2, 4.2.3.5
index size
estimating, 7.5.5
ttSize utility, 7.5.5
indexes
and performance, 9.3.1
automatic creation, 7.2.1.5
creating, 7.2.1.5, 7.5.2
dropping, 7.5.4, 7.5.4
estimating size, 7.5.5
overview, 7.5
owner, 7.5.2
referencing, 7.5.4
See also range indexes
See also bitmap index
See also hash indexes
unique, 7.5, 7.5
informational messages
modifying, 3.4.2
in-line columns, 7.2.1.2
INSERT ANY privilege, 4.2.2.5
INSERT privilege, 4.2.3.2
inserting rows, 7.6.1
INSTR SQL function, 5.6
INSTR4 SQL function, 5.6
INSTRB SQL function, 5.6
interactive mode
ttIsql, 6.1
I/O
performance, 9.5.1
IPC
Client/Server communication, 3.5.5
isolation command
ttIsql utility, 6.11
isolation level
performance, 9.2.3.2
isolation modes
described, 8.6
Serializable, 8.6.1
IXNAME column in PLAN table, 10.3.1.3.5

J

JDBC
driver, 1.1.2
driver manager, 1.1.2
JDBC tracing, 9.1.13
join
columns, view performance, 9.4.2
rows, view performance, 9.4.1

L

large page support
Linux, 3.4.5
least recently used aging, 7.2.3.1
length semantics, 5.3
LENGTH SQL function, 5.6
LENGTH4 SQL function, 5.6
LENGTHB SQL function, 5.6
LEVEL column in PLAN table, 10.3.1.3.2
linguistic index, 5.5.5
linguistic sort
monolingual, 5.5.1
multilingual, 5.5.2
linguistic sorts
accent-insensitive, 5.5.3
case-insensitive, 5.5.3
linking applications
direct, 1.1
with driver manager, 1.1
Linux
large page support, 3.4.5
-linuxLargePageAlignment option
ttendaemon.options file, 3.4.5
-listenaddr entry
ttendaemon.options file, 3.4.1
-listenaddr option
ttendaemon.options file, 3.4.1
-listenaddr6 option
ttendaemon.options file, 3.4.1.1
LOAD ANY CACHE GROUP privilege, 4.2.5.2
LOAD privilege, 4.2.5.3
lock
set wait time, 8.6.2.1
locking
See also locks
See also ttLockLevel
LockLevel connection attribute, 9.2.3
locks
and concurrency, 9.2.3.1
and performance, 9.2.3
coexistence of different levels
database-level, 8.6.2, 9.2.3.1
overview table, 8.2
reduce contention, 9.1.9
row-level, 8.6.2, 9.2.3.1
table-level, 8.6.2, 9.2.3.1
timeout interval and performance, 9.2.2
LockWait attribute, 8.6.2.1
LogFlushMethod connection attribute, 9.5.2
logging
managing, 3.5.6
overview table, 8.2
temporary database, 7.1.3
logical server
Network Address, 2.1.2.3, 2.2.4.1, 2.2.4.2
logical server name
creating on UNIX, 2.2.4.2
LOWER and UPPER SQL functions, 5.6
LRU aging, 7.2.3.1
LRU aging attributes, 7.2.3.1

M

maintenance options
performance impact, 9.1.11
materialized view
asynchronous
create, 7.4.2.1.2
overview, 7.4.1.2
create, 7.4.2.1
detail table, 7.4.1
drop, 7.4.2.2, 7.4.2.2
invalidated, 4.2.3.5.1
performance, 7.4.2.4.2
restrictions, 7.4.2.3
SELECT queries in, 7.4.2.1.3
synchronous
create, 7.4.2.1.1
overview, 7.4.1.1
understanding, 7.4
materialized view log
drop, 7.4.2.2, 7.4.2.2
materialized views
privileges, 4.2.3.5
-maxConnsPerServer option
ttendaemon.options file, 3.5.4
maximum name length, 7.2.1.4
-maxsubs option
ttendaemon.options file, 3.4.3
-maxsupportlogfiles option
ttendaemon.options file, 3.4.2
-maxsupportlogsize option
ttendaemon.options file, 3.4.2
-maxuserlogfiles option
ttendaemon.options file, 3.4.2
-maxuserlogsize option
ttendaemon.options file, 3.4.2
memory
loading a database into, 1.9
partitions, 1.10
permanent, 1.10
policy for loading a database, 1.9
temporary, 1.10
messages
informational, 2.3.1, 3.4.2
server log, 2.3.1
turn off, 3.4.2
metadata, TimesTen, 7.2.1.7
method
getConnection, 2.2.5
methods
Connection.prepareStatement, 10.3.1
Connection.setAutoCommit, 8.1.1.1, 8.1.1.1
migrating
database, 1.12.1
-minsubs option
ttendaemon.options file, 3.4.3
modifying execution plan
overview, 10.4
procedure overview, 10.4.3
monitor command
ttIsql utility, 6.8, 6.8.4

N

names
log files, 8.5.1
maximum, 7.2.1.4
naming a Client DSN, 2.2.5.1.1
NCHR SQL function, 5.6
nested subqueries
and performance, 9.3.8
Network Address for logical server
ttLocalHost, 2.1.2.3
ttShmHost, 2.1.2.2
UNIX, 2.2.4.2
Windows, 2.2.4.1
NFS mounted systems
restriction, 3.4.4
NLS_LENGTH_SEMANTICS general connection attribute, 5.3, 5.3
NLS_SORT connection attribute, 5.5.4
NLSSORT SQL function, 5.5.4
non-durable commit, 9.5.2
non-durable commits
advantages and disadvantages, 9.5.2
-noserverlog option
ttendaemon.options file, 3.5.6
not inline columns, 7.2.1.2
NULL values, sorting, 7.5
nullable columns
definition, 7.2
primary key not nullable, 7.2.1.6

O

object
privileges
ALL keyword, 4.2.3.1
object privileges
functions, 4.2.3.7
granting, 4.2.1.2, 4.2.3
materialized views, 4.2.3.5
object
cache group, 4.2.5.3
overview, 4.2.1.2
packages, 4.2.3.7
procedures, 4.2.3.7
revoking, 4.2.3
sequences, 4.2.3.4
tables, 4.2.3.2
view user grants, 4.2.6
views, 4.2.3.3
ODBC
tracing and performance, 9.1.13
UNIX driver, 1.3.2.1
ODBC functions
and the JDBC driver, 1.1.2
odbc.ini, 1.2.1, 1.2.1
entry example, 1.7.3
format of, 1.7.3
online help, 6.4
operating system
paging, 9.1.10
OPERATION column in PLAN table, 10.3.1.3.3
optimizer
application hints, 10.1
example scenario, 10.1, 10.1
generating plan, 10.3.1.1
invalid statistics, 9.3.6, 10.1
modifying execution plan, 10.4
PLAN row example, 10.3.1.2
query plan, 10.3.1
reading plan, 10.3.1.2
optimizer hints
ttOptSetFlag procedure, 9.2.3
optprofile command
ttIsql utility, 6.15.1
OTHERPRED column in PLAN table, 10.3.1.3.7
OUT parameters, 6.14
outer join
materialized view performance, 9.4.4
out-of-memory warnings, 1.10.4
owners
of indexes, 7.5.2

P

packages
object privileges, 4.2.3.7
packages command
ttIsql utility, 6.9
performance
and altered tables, 9.3.7
and autocommit, 8.1.1.1, 8.1.1.1
and foreign key constraints, 9.3.4
and isolation modes, 9.2.3.2
and temporary databases, 9.1.4
application tuning
autocommit mode, 9.5.4
checkpoints, 9.5.3
connection overhead, 9.1.6
durable commits, 9.5.2
maintenance options, 9.1.11
ODBC tracing, 9.1.13
transaction rollback, 9.5.5
transaction size, 9.5.1
automatic index creation, 7.2.1.5
Client, 9.2.1
database tuning
driver usage, 9.1.12
specifying size, 9.1.2
temporary database, 9.1.5
join columns in materialized views, 9.4.2
join rows in materialized views, 9.4.1
lock timeout interval, 9.2.2
materialized views, 9.4.4
replication throughput, 9.1.16
SQL tuning
indexes, 9.3.1
prepare operations, 9.3.10
temporary database, 9.1.5
tuning, 9
using privileges, 4.2.3.2
working locally, 9.2.1
permanent data partition, 1.10.1
permanent database, 7.1.3
automatic checkpointing, 7.1.3
PermSize attribute, 1.10, 1.10
monitoring, 1.10.3
specifying, 9.1.2
PermWarnThreshold attribute, 1.10.4
phantoms, 9.2.3.2
plan
See execution plan, 10.3.1.3
PLAN rows, 10.3.1.2
PLAN table
columns, 10.3.1.3
IXNAME column, 10.3.1.3.5
LEVEL column, 10.3.1.3.2
OPERATION column, 10.3.1.3.3
OTHERPRED column, 10.3.1.3.7
PRED column, 10.3.1.3.6
STEP column, 10.3.1.3.1
TBLNAME column, 10.3.1.3.4
PLSCOPE_SETTINGS connection attribute, 1.6.2
PL/SQL
creating and executing blocks, 6.13
shared memory sizing, 9.1.3
PL/SQL host variables
using ttIsql, 6.12
PL/SQL objects
using ttIsql to list, 6.9
PLSQL_MEMORY_ADDRESS connection attribute, 1.6.2
PLSQL_MEMORY_SIZE attribute, 9.1.3
PLSQL_MEMORY_SIZE connection attribute, 1.6.2
PLSQL_OPTIMIZE_LEVEL connection attribute, 1.6.2
PRED column in PLAN table, 10.3.1.3.6
limit on length, 10.3.1.3.6
prefetch multiple update records, 9.8.2
prepare command
ttIsql utility, 6.12
PreparedStatement objects, 10.4.2, 10.4.2
preparing statements, 10.3.1, 10.3.1
primary keys, 7.2.1.6
nullability, 7.2.1.6
See Also unique indexes
privileges
ADMIN, 4.2.1.1, 4.2.2
administrator, 4.2.1.1
ALL keyword, 4.2.3.1
ALL keyword system privileges, 4.2.2.2
ALTER ANY, 4.2.2.5.1, 4.2.3.7
ANY, 4.2.2.5
authorizing, 4.2.1
cache group, 4.2.1.2, 4.2.5, 4.2.5.3
CACHE_MANAGER, 4.2.5.1
CREATE ANY, 4.2.2.5.1
CREATE SESSION, 4.2.2.3
CREATE system, 4.2.2.5.1
definition, 4.2.1
DELETE, 4.2.3.2
DELETE ANY, 4.2.2.5
DROP ANY, 4.2.2.5.1
EXECUTE, 4.2.3.7
EXECUTE ANY, 4.2.2.5
first connection attributes, 4.2.2.3
grant system, 4.2.2
granting rights, 4.2.1
granting system privileges, 4.2.1.1
hierarchy rules, 4.2.1.4
INDEX, 4.2.3.2
INSERT ANY, 4.2.2.5
levels, 4.2.1
object, 4.2.1.2, 4.2.3.3
cache group, 4.2.5.3
functions, 4.2.3.7
granting, 4.2.1.2, 4.2.3
materialized views, 4.2.3.5
packages, 4.2.3.7
procedures, 4.2.3.7
revoking, 4.2.3
sequences, 4.2.3.4
tables, 4.2.3.2
overview, 4.2
parent-child table rules, 4.2.8
performance, 4.2.3.2
REFERENCES, 4.2.3.2
replication, 4.2.1.2
revoke system, 4.2.2
revoking ALL, 4.2.2.2
role, 4.2.1.3
SELECT, 4.2.3.2, 4.2.3.3, 4.2.3.4, 4.2.3.5
SELECT ANY, 4.2.2.5
system
overview, 4.2.1.1
UPDATE, 4.2.3.2
UPDATE ANY, 4.2.2.5
view user grants, 4.2.6
XLA, 4.2.2.4
procedure, 7.4.2.4.1
procedures
object privileges, 4.2.3.7
procedures command
ttIsql utility, 6.9
PUBLIC role, 4.2.1.3
role
PUBLIC, 4.2.1.3

Q

query
plan, 10.3.1
query optimizer
See optimizer
query optimizer plans, 10.1
viewing with ttIsql, 6.15.1
query plan
display, 6.15.2.2

R

RAM policy
defined, 1.9
range index, 9.3.2
range indexes
overview, 7.5.1
RecoveryThreads attribute, 9.1.16
REF CURSOR
using ttIsql, 6.12
REFERENCES privilege, 4.2.3.2, 4.2.3.5, 4.2.3.6
referencing indexes, 7.5.4
REFRESH ANY CACHE GROUP privilege, 4.2.5.2
REFRESH privilege, 4.2.5.3
remote database
accessing on UNIX, 2.2.4.2, 2.2.5.2.1, 2.4, 2.4.1
accessing on Windows, 2.2.5.1.4
removing
columns, 7.2.1.1
rows, 7.2.1.1
replication
aging, 7.2.3.5
character sets, 5.2.4
privileges, 4.2.1.2
temporary data partition, 1.10.1
TimesTen daemon, 3
TTREP system tables, 7.2.1.4
replication performance, 9.1.16
.res files, 8.7.2
restore
database, 1.12.2
restrictions on table names, 7.2.1.4
REVOKE ALL command, 4.2.2.2, 4.2.3.1
REVOKE command, 4.2.2, 4.2.3
role
PUBLIC, 4.2.1.3
rollback
logs and locks, 8.2
performance impact, 9.5.5
rollback command
ttIsql utility, 6.11
row-level locks, 8.6.2
rows
adding, 7.2.1.1
adding to a table, 1.12.1
deleting, 7.6.2
in-line and out-of-line portions, 7.2.1.2
inserting, 7.6.1
understanding, 7.6
RTRIM SQL function, 5.6

S

saving command history
ttIsql, 6.6.1
schema
definition, Glossary
SELECT ANY privilege, 4.2.2.5
SELECT privilege, 4.2.3.2, 4.2.3.3, 4.2.3.4, 4.2.3.5, 4.2.3.5
sequences
object privileges, 4.2.3.4
Serializable isolation mode, 8.6.1
serializable transaction
performance, 9.2.5
Server
controlling, 3.5.2
creating a DSN, 2.2.3
creating DSN, 2.2.3
creating logical name, 2.2.4.1
on UNIX, 2.2.4.2
described, 2.3
modifying options, 3.5.1
name, 2.2.4.1, 2.2.5.1.1
creating on Windows, 2.2.4.1
number of processes, 3.5.4.2
port number, 3.5.2
prespawning processes, 3.5.3
Server List dialog, 2.2.4.1
Server Name Setup dialog, 2.2.4.1
specifying number of connections, 3.5.4
starting, 3.5.2
starting and stopping, 2.3
thread stack size, 3.5.4.3
Server daemon
modifying options, 3.5.1
Server log messages
controlling, 3.5.6
-server option
ttendaemon.options file, 3.5.2
-serverpool option
ttendaemon.options file, 3.5.3
-serverShmIpc option
ttendaemon.options file, 3.5.5
-serverShmSize option, 3.5.5.1
ttendaemon.options file, 3.5.5.2
-serversPerDSN option
ttendaemon.options file, 3.5.4.2
-serverStackSize option
ttendaemon.options file, 3.5.4.3
service
See daemon
setjoinorder command
ttIsql utility, 6.15.1
setting the timeout interval on Windows, 2.2.5.1.3
setuseindex command
ttIsql utility, 6.15.1
shared memory
changing size, 3.5.5.2
Client/Server IPC, 3.5.5
Client/Server, managing size, 3.5.5.1
IPC-enabled server, 3.5.5
sizing, 9.1.3
shared memory segment
managing size, 3.5.5.1
size, 3.5.5.2
-shmLocalityHint option
ttendaemon.options file, 3.4.6
-showdate option
ttendaemon.options file, 3.4.2
showplan command, 6.12, 6.15.1
ttIsql utility, 6.15.1
size
database, 1.10
sizing
hash indexes, 9.3.3
transactions, 9.5.1
SNMP traps
described, 1.10.4
sorting NULL values, 7.5
SQL
query plan, 10.3.1
tuning and performance, 9.3
SQL Command Cache
viewing commands, 6.15.2.1
SQL command cache
invalidated, 10.1
invalidation, 9.3.6
SQLPrepare, 10.3.1
and execution plan generation, 10.4.2
performance impact, 9.3.10
sqlquerytimeout command
ttIsql utility, 6.11
starting and stopping the Server, 2.3
starting and stopping the TimesTen Data Manager, 3.1
static checkpoints, definition
statistics
computing, 9.3.5
recomputation, 9.3.6, 10.1, 10.1
ttOptEstimateStats, 9.3.5
ttOptUpdateStats, 9.3.5
STEP column in PLAN table, 10.3.1.3.1
subdaemons
definition, 3.4.3
minimum required, 3.4.3
setting allowable number, 3.4.3
specifying allowable range, 3.4.3
SUBSTR SQL function, 5.6
SUBSTR4 SQL function, 5.6
SUBSTRB SQL function, 5.6
-supportlog option
ttendaemon.options file, 3.4.2
synchronous checkpoints
See static checkpoints
synonym
create, 7.7, 7.7.1
definition, 7.7
drop, 7.7.2
invalidation, 7.7.3
private, 7.7
public, 7.7
recompiled, 7.7.3
required privileges, 4.2.3.8
viewing, 7.7
SYS owner of tables, 7.2.1.4
syslog
specify facility, 3.4.2
SYS.MONITOR table, 1.10.3, 9.5.2, 9.8.1
System DSN, 1.3.1.1, 2.2.4.1, 2.2.5.1.5
system failure
resulting logs and locks, 8.2
system privileges
ANY, 4.2.2.5
cache group, 4.2.5
CREATE, 4.2.2.5.1
default privileges, 4.2.2.1
granting, 4.2.1.1, 4.2.2
granting ALL, 4.2.2.2
overview, 4.2.1.1
revoking, 4.2.2
view user grants, 4.2.6
system tables
access, 4.2.2.1
indexes on, 7.5.2
overview, 7.2.1.7

T

table size
estimating, 7.2.2.3
ttSize utility, 7.2.2.3
table-level locks, 8.6.2
tables
adding rows, 1.12.1
creating, example, 7.2.2.1
creating, examples, 7.2.2.1
deleting rows, 7.6.2
dropping, example, 7.2.2.2, 7.4.2.2
estimating size, 7.2.2.3
format, 7.2
in-line vs. not inline columns, 7.2.1.2
inserting rows, 7.6.1
modifying format, 7.2.1.1
name length, 7.2.1.4
names, 7.2.1.4
names, restrictions, 7.2.1.4
nullable columns, 7.2
object privileges, 4.2.3.2
owners, 7.2.1.4
SYS owner, 7.2.1.4
system, 4.2.2.1
understanding rows, 7.6
unique indexes
TBLNAME column in PLAN table, 10.3.1.3.4
TCP/IP
Client/Server
communication, 2.1.2.1
Temporary attribute
performance, 9.1.4, 9.1.5
temporary data partition
and replication, 1.10.1
temporary database, 7.1.3
logging, 7.1.3
TempSize attribute, 1.10, 1.10
monitoring, 1.10.3
specifying, 9.1.2
testing connections on Windows, 2.2.5.1.5
thread programming, 1.13
time-based aging, 7.2.3.2
timeout interval
setting on Windows, 2.2.5.1.3
TimesTen
ODBC driver, 1.1.1
TimesTen daemon
options, 3.4
TIMESTEN8 character set, 5.7.1
timestend, 3
timing command
ttIsql utility, 6.16
timing ODBC function calls, 6.16
transaction
commit
logs and locks, 8.2
durable commit, 9.5.1
locking, 9.2.3
log files
how to control, 8.5.1
names, 8.5.1
logging, 8.5.1
management
isolation levels, 8
locking, 8.2
logging, 8.2
semantics, 8.2
performance, 8.4.3, 9.5.1, 9.5.2
rollback
logs and locks, 8.2
performance impact, 9.5.5
serializable
performance, 9.2.5
sizing, 9.5.1
ttIsql utility, 6.11
XLA, 9.8.1
tryhash command
ttIsql utility, 6.15.1
trymergejoin command
ttIsql utility, 6.15.1
trynestedloopjoin command
ttIsql utility, 6.15.1
tryrowid command
ttIsql utility, 6.15.1
tryserial command
ttIsql utility, 6.15.1
trytbllocks command
ttIsql utility, 6.15.1
trytmphash command
ttIsql utility, 6.15.1
trytmptable command
ttIsql utility, 6.15.1
trytmpttree command
ttIsql utility, 6.15.1
tryttree command
ttIsql utility, 6.15.1
TT_PREFETCH_CLOSE connection option, 9.2.5
ttAgingLRUConfig built-in procedure, 7.2.3.1
ttBlockInfo utility, 1.10.3
ttconnect.ini file, 2.2.4.3
ttdaemon.options file
changing, 3.4
ttDurableCommit procedure, 9.5.2
ttendaemon.options file, 3.4, 3.4.2, 3.4.2, 3.4.3, 3.5.5, 3.5.5.1
-allowNetworkFiles option, 3.4.4
-enableIPv6, 3.4.1.1
-enablePolicyInactive option, 3.4.7
-facility option, 3.4.2
-linuxLargePageAlignment option, 3.4.5
-listenaddr entry, 3.4.1
-listenaddr option, 3.4.1
-listenaddr6 option, 3.4.1.1
-maxConnsPerServer option, 3.5.4
-maxsubs option, 3.4.3
-maxsupportlogfiles option, 3.4.2
-maxsupportlogsize option, 3.4.2
-maxuserlogfiles option, 3.4.2
-maxuserlogsize option, 3.4.2
-minsubs option, 3.4.3
modifying server options, 3.5.1
-noserverlog option, 3.5.6
-server option, 3.5.2
-serverpool option, 3.5.3
-serverShmlpc option, 3.5.5
-serverShmSize option, 3.5.5.1, 3.5.5.2
-serversPerDSN option, 3.5.4.2
-serverStackSize option, 3.5.4.3
-shmLocalityHint option, 3.4.6
-showdate, 3.4.2
specify syslog facility, 3.4.2
-supportlog option, 3.4.2
turn off messages, 3.4.2
-verbose option, 3.4.2
ttIsql, 6.4
autocommit command, 6.11
built-in command usage, 6.8, 6.11, 6.12, 6.15.1
cachegroups command, 6.8, 6.8.2
clearing command history, 6.6.1
cmdcache command, 6.15.2.1
command history, 6.6
commit command, 6.11
commitdurable command, 6.11
connect command, 6.16
customizing command prompt, 6.3
deleting rows, 7.6.2
describe command, 6.8, 6.8.1
displaying database information, 6.8
dssize command, 6.8, 6.8.3
editline feature, 6.5
explain command, 6.15.2.2
isolation command, 6.11
modes, interactive and batch, 6.1
monitor command, 6.8, 6.8.4
online help, 6.4
rollback command, 6.11
saving command history, 6.6.1
showplan command, 6.15.1
sqlquerytimeout command, 6.11
timing command, 6.16
timing ODBC function calls, 6.16
using, 6
using OUT parameters, 6.14
view and set connection attributes, 6.10
viewing optimizer plan, 6.15.1
working with character sets, 6.7
working with parameterized SQL statements, 6.12
working with prepared SQL statements, 6.12
working with transactions, 6.11
TTISQL environment variable, 6.2
ttLocalHost
logical server address, 2.1.2.3
ttmodinstall utility, 3.4
ttOptClearStats built-in procedure, 10.4.3
ttOptCmdCacheInvalidate built-in procedure, 9.3.6
ttOptEstimateStats, 7.4.2.4.1
statistics computing, 9.3.5
ttOptEstimateStats built-in procedure, 7.4.2.4.1, 10.4.3
ttOptSetFlag procedure, 9.2.3
TTREP system tables, 7.2.1.4
ttShmHost, 2.2.4.3.1
logical server address, 2.1.2.2
ttSize utility, 1.10.1
ttSqlCmdCacheInfo built-in procedure, 6.15.2.1
ttSqlCmdQueryPlan built-in procedure, 6.15.2.2
ttStatus utility, 1.10.2
ttWarnOnLowMemory procedure, 1.10.4

U

UID connection attribute, 7.1.2
unique indexes, 7.5
See also primary key
UNISTR SQL function, 5.6
UNIX
setting attributes, 1.3.2.1
UNIX configuration file
odbc.ini, 1.7.3
UNIX configuration files
.odbc.ini, format of, 1.7.3
UNIX socket
Client/Server communication, 2.1.2.3
UNLOAD ANY CACHE GROUP privilege, 4.2.5.2
UNLOAD privilege, 4.2.5.3
unsetjoinorder command
ttIsql utility, 6.15.1
unsetuseindex command
ttIsql utility, 6.15.1
UPDATE ANY privilege, 4.2.2.5
UPDATE privilege, 4.2.3.2
updates
materialized view performance, 9.4.3
usage-based aging, 7.2.3.1
USER_SYS_PRIVS view, 4.2.2, 4.2.6
USER_TAB_PRIVS view, 4.2.6
USER_USERS view, 4.1.2
-userlog option
ttendaemon.options file, 3.4.2
UTL_RECOMP package, 4.2.2.1

V

-verbose option
ttendaemon.options file, 3.4.2
view
creating, 7.3.1
drop, 7.3.2
overview, 7.3
restrictions, 7.3.3
SELECT query, 7.3.1.1
views, 4.2.3.3
object privileges, 4.2.3.3

W

working with
parameterized SQL statements, 6.12
prepared SQL statements, 6.12

X

XLA
bookmark, deleting, 6.17
performance, 9.8.1
privilege, 4.2.2.4
updates
acknowledging, 9.8.3
xlabookmarkdelete command
ttIsql utility, 6.17