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

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

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

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

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