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

ttIsql command, 6.11

allpackages

ttIsql command, 6.11

allprocedures

ttIsql command, 6.11

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.6

REFERENCES privilege, 4.2.3.6

ANY system privileges, 4.2.2.5

application

shut down, 3.3

application failure

use of logs and locks, 8.2

ASCIISTR SQL function, 5.6

asynchronous checkpoints

See fuzzy checkpoints

attributes

and data source name, 1.5.3

connection, 2.7

PermWarnThreshold, 1.6.3

setting for UNIX, 1.4.4.2

specifying, 1.3.3

TempWarnThreshold, 1.6.3

viewing and changing by ttIsql, 6.12

AUTO_ACKNOWLEDGE mode, 9.8.2

autocommit

performance impact, 9.5.4

autocommit ttIsql command, 6.7

automatic

checkpointing, 8.6.2

index creation, 7.2.1.5

B

backup

data store, 1.8, 1.8.1

full, 1.8.1

incremental, 1.8.1

stream, 1.8.1

types, 1.8.1

batch mode

ttIsql, 6.1

bitmap index, 9.3.2

when used, 7.5.1

built-in procedure

ttDurableCommit, 8.4

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

privilege

CACHE_MANAGER, 4.2.5.3

privileges, 4.2.1.2, 4.2.5.3

required privileges for AWT, 4.2.5.1

cache groups

time-based aging, 7.2.3.2

CACHE_MANAGER privilege, 4.2.5.1, 4.2.5.3

cachegroups ttIsql command, 6.8

case-insensitive linguistic sort, 5.5.3

ccNUMA, 3.4.6

changing shared memory segment size, 3.5.5.2

character semantics, 5.3

character set

and replication, 5.2.4

choosing, 5.2

working with in ttIsql, 6.6

checkpoints

and performance, 9.5.3

automatic, 7.1.3, 8.6.2

fuzzy

influences on duration, 8.6

static

CHR SQL function, 5.6

clearing command history

ttIsql, 6.5.1

client

configuring automatic failover on UNIX, 2.9.4

configuring automatic failover on Windows, 2.8.3

connection attributes

described, 2.5, 2.7

creating DSN

on UNIX, 2.9.3

on Windows, 2.8.2

performance, 9.2.1

Client DSN

creating, 2.9

creating on UNIX, 2.9.3

creating on Windows, 2.8.2

Data Source Setup dialog, 2.8.2

name, 2.8.2

CLIENT_ACKNOWLEDGE mode, 9.8.3

Client/Server

changing shared memory segment size, 3.5.5.2

configuring, 2.3

connections across bit-levels, 2.3.2

connections across releases, 2.3.2

managing shared memory segment size, 3.5.5.1

client/server

communication

overview, 2.2

TCP/IP communication, 2.2.1, 2.2.1

UNIX socket communication, 2.2.3, 2.2.3

Client/Server communication

shared memory, 3.5.5

TCP/IP, 3.5.5

close ttIsql command, 6.15

coexistence of different locking levels

column values

default, 7.2.1.3

columns

adding, 7.2.1.1

in-line, 7.2.1.2

nullability, 7.2.1.1

command history

ttIsql, 6.5

commit behavior

Oracle, 8.1

TimesTen, 8.1

commit ttIsql command, 6.7

commitdurable ttIsql command, 6.7

components of data store, 7.1.1

concurrency

locking, 9.2.3.1

logging, 8.4

types of isolation, 8.5

configuring

Client/Server, 2.3

Connection

commit method, 8.2

rollback method, 8.2

setAutoCommit method, 8.2, 8.2

connection

locking, 9.2.3

locks, 9.2.2

timeout interval, 9.2.2

connection attribute

connection, 2.5

LockLevel, 9.2.3

LogFlushMethod, 9.5.2

PermSize, 1.6.1, 1.6.2

PLSCOPE_SETTINGS, 1.5.2

PLSQL_MEMORY_ADDRESS attribute, 1.5.2

PLSQL_MEMORY_SIZE attribute, 1.5.2

PLSQL_OPTIMIZE_LEVEL, 1.5.2

TempSize, 1.6.1, 1.6.2

connection character set, 2.8.2, 5.4

ConnectionCharacterSet general connection attribute, 5.4

Connection.prepareStatement method, 10.3.1

and execution plan generation, 10.4.2

connections

performance overhead, 9.1.6

testing on Windows, 2.8.7

contention

lock, 9.1.8

controlling logging, 8.4

controlling Server log messages, 3.5.6

controlling the TimesTen Server daemon, 3.5.2

copying a data store, 1.8

CREATE ANY CACHE GROUP privilege, 4.2.5.2

CREATE ANY privilege, 4.2.2.5.1

CREATE ANY TABLE privilege, 4.2.5.2

CREATE CACHE GROUP privilege, 4.2.5.2

CREATE INDEX statement, 7.5.2

CREATE privilege, 4.2.2.5.1

CREATE SESSION privilege, 4.2.2.3, 4.2.2.3

CREATE TABLE privilege, 4.2.5.2

creating indexes

example, 7.5.2

explicit creation, 7.2.1.5

how to do, 7.5.2

creating tables

example, 7.2.2.1

cursor

closing, 8.1

Custom setup, Windows, 1.1.1

D

daemon

control operations, 3.4.3

informational messages on Windows

options, 3.4

overview, 3

starting and stopping on UNIX, 3.2

starting and stopping on Windows, 3.1

data

permanent, 1.6.1

temporary, 1.6.1

Data Manager Service, 3.1

data source

specification, 1.9.5

UNIX configuration files, 1.9.6

data source names, See DSN

data store

accessing on a local machine, 2.2.3

accessing on a remote machine, 2.2.1

backup, 1.8, 1.8

changing size of, 1.6.2

components, 7.1.1

contention, 9.1.8

copying, 1.8

definition, 1

estimating size, 9.1.2

getting information with ttIsql, 6.8

lock contention, 9.1.8

migrating, 1.8

path names, environment variables in, 1.4.4.3

permanent, 7.1.3

prefix name, 1.4.4

restoring, 1.8

setting attributes for UNIX, 1.4.4.2

sizing, 9.1.2, 9.1.2

TCP/IP client/server access, 2.2.1

temporary, 1.5.1, 7.1.3, 9.1.5

UID connection attribute, 7.1.2

UNIX socket client/server access, 2.2.3

user names, 7.1.2

users and owners, 7.1.2

data store-level locks, 8.5.2, 8.5.2

database

connecting, 4.2.2.3, 4.2.2.3

database character set

application, 5.2.2

client operating system, 5.2.2

languages, 5.2.1

performance, 5.2.3

DatabaseCharacterSet data store attribute, 5.2

database-level locks, 8.5.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

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.8.5

describe ttIsql command, 6.8, 6.15

detail table, 7.4.1

diagnostics

SNMP traps, 1.6.3

driver

JDBC, 1.3.1

DRIVER attribute, 1.4.3

driver manager

JDBC, 1.1.2

linking with, 1.1

ODBC, 1.1

DriverManager.getConnection method, 2.7, 2.7

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

dropping

indexes, 7.5.4

tables, example, 7.2.2.2

DSN, 4.2.2.3

Client, 1.2.2, 1.2.2

connection attributes, Data Manager, 1.2.3

Data Manager, 1.2.2

example, 1.5

example, Windows

finding in order of precedence, 2.9.1

maximum length, 1.2

naming rules, 1.2

.odbc.ini file, 1.9.1

setting attributes, 1.5.3

system, 1.2.1

user, 1.2.1

dssize ttIsql command, 6.8

DUPS_OK_ACKNOWLEDGE mode, 9.8.2

durability

overview, 8.3

durable commit

performance, 9.5.2

transactions, 9.5.1

E

editline for ttIsql, 6.4

environment variables

in data store path names, 1.4.4.3

TTISQL, 6.16

examples

creating indexes, 7.5.2

creating tables, 7.2.2.1

drop materialized view, 7.4.2.2

drop materlialized view log, 7.4.2.2

dropping tables, 7.2.2.2

PLAN rows, 10.3.1.2

exec ttIsql command, 6.15

execandfetch ttIsql command, 6.15

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

F

failover

configuring for client on UNIX, 2.9.4

configuring for client on Windows, 2.8.3

fetchall ttIsql command, 6.15

fetchone ttIsql command, 6.15

files

odbc.ini, 1.9.1, 1.9.6

.ttconnect.ini, 2.11

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.6.2.3

free ttIsql command, 6.15

functions

object privileges, 4.2.3.7

ttIsql command, 6.11

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.15

I

index

aging performance, 7.2.3.2

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.12

join

columns, view performance, 9.4.2

rows, view performance, 9.4.1

L

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

LOAD ANY CACHE GROUP privilege, 4.2.5.2

LOAD privilege, 4.2.5.3

loading a data store to memory, 1.7

locking

M

maintenance options

performance impact, 9.1.10

managing shared memory segment size, 3.5.5.1

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

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

maximum name length, 7.2.1.4

memory

loading a data store into, 1.7

partitions, 1.6.1

permanent, 1.6.1

policy for loading a data store, 1.7

temporary, 1.6.1

messages

informational, 2.4.1

server log, 2.4.1

metadata, TimesTen, 7.2.1.7

method

getConnection, 2.7

methods

Connection.commit, 8.2

Connection.prepareStatement, 10.3.1

Connection.rollback, 8.2

Connection.setAutoCommit, 8.2, 8.2

migrating data stores, 1.8

modifying execution plan

overview, 10.4

procedure overview, 10.4.3

modifying informational messages, 3.4.2

modifying Server daemon options, 3.5.1

monitor ttIsql command, 6.8

N

names

log files, 8.4.2

maximum, 7.2.1.4

naming a Client DSN, 2.8.2

NCHR SQL function, 5.6

nested subqueries

and performance, 9.3.7

Network Address for logical server

ttLocalHost, 2.2.3

ttShmHost, 2.2.2

UNIX, 2.9.2

Windows, 2.8.1

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

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

CACHE_MANAGER, 4.2.5.3

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.12

UNIX driver, 1.4.3

ODBC functions

and the JDBC driver, 1.1.2

odbc.ini, 1.9.1, 1.9.1

entry example, 1.9.6

format of, 1.9.6

online help, 6.3

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, 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 ttIsql command, 6.13

OS paging, 9.1.9

OTHERPRED column in PLAN table, 10.3.1.3.7

OUT parameters, 6.10

outer join

materialized view performance, 9.4.4

out-of-memory warnings, 1.6.3

owners

of indexes, 7.5.2

P

packages

object privileges, 4.2.3.7

ttIsql command, 6.11

performance

and altered tables, 9.3.6

and autocommit, 8.2, 8.2

and foreign key constraints, 9.3.4

and isolation modes, 9.2.3.2

and temporary data stores, 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.10

ODBC tracing, 9.1.12

transaction rollback, 9.5.5

transaction size, 9.5.1

automatic index creation, 7.2.1.5

Client, 9.2.1

data store tuning

driver usage, 9.1.11

specifying size, 9.1.2

temporary vs. permanent data store, 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.15

SQL tuning

indexes, 9.3.1

prepare operations, 9.3.9

tuning, 9

using privileges, 4.2.3.2

working locally, 9.2.1

permanent data partition, 1.6.2.1

permanent data store, 7.1.3

automatic checkpointing, 7.1.3

PermSize attribute, 1.6.1, 1.6.2

monitoring, 1.6.2.3

specifying, 9.1.2

PermWarnThreshold attribute, 1.6.3

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.5.2

PL/SQL

creating and executing blocks, 6.9

shared memory sizing, 9.1.3

PL/SQL host variables

using ttIsql, 6.15

PL/SQL objects

using ttIsql to list, 6.11

PLSQL_MEMORY_ADDRESS connection attribute, 1.5.2

PLSQL_MEMORY_SIZE attribute, 9.1.3

PLSQL_MEMORY_SIZE connection attribute, 1.5.2

PLSQL_OPTIMIZE_LEVEL connection attribute, 1.5.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 ttIsql command, 6.15

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.13

R

RAM policy

defined, 1.7

range index, 9.3.2

range indexes

overview, 7.5.1

RecoveryThreads attribute, 9.1.15

REF CURSOR

using ttIsql, 6.15

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 data store

accessing on UNIX, 2.9.2, 2.9.3, 2.10, 2.10.1

accessing on Windows, 2.8.6

removing

columns, 7.2.1.1

rows, 7.2.1.1

replication

aging, 7.2.3.5

and TimesTen daemon, 3

character sets, 5.2.4

privileges, 4.2.1.2

temporary data partition, 1.6.2.1

TTREP system tables, 7.2.1.4

replication performance, 9.1.15

.res files, 8.6

restore

data store, 1.8.1

restoring a data store, 1.8

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 ttIsql command, 6.7

row-level locks, 8.5.2

rows

adding, 7.2.1.1

adding to a table, 1.8

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.5.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

sequences

object privileges, 4.2.3.4

SERIALIZABLE isolation mode, 8.5.1

serializable transactions

performance, 9.2.5

Server

controlling the daemon, 3.5.2

described, 2.4

modifying daemon, 3.5.1

name, 2.8.2, 2.8.5

Server List dialog, 2.8.1

Server Name Setup dialog, 2.8.1

starting and stopping, 2.4

server

creating a DSN, 2.6

creating DSN, 2.6

creating logical name, 2.8.1

on UNIX, 2.9.2

Server log messages, 3.5.6

server name

creating on Windows, 2.8.1

serverShmIpc, 3.5.5

serverShmSize, 3.5.5.2

Service

See daemon

setjoinorder ttIsql command, 6.13

setting data store attributes

UNIX, 1.4.4.2

setting the timeout interval on Windows, 2.8.4

setuseindex ttIsql command, 6.13

shared data store

durable and nondurable connections, 8.4

shared memory

Client/Server IPC, 3.5.5

Client/Server, changing size, 3.5.5.2

Client/Server, managing size, 3.5.5.1

sizing, 9.1.3

shared memory IPC-enabled server, 3.5.5

showplan command, 6.13, 6.13, 6.15

shutting down a TimesTen application, 3.3

size

data store, 1.6.2

sizing

data stores, 9.1.2

hash indexes, 9.3.3

transactions, 9.5.1

SNMP traps

described, 1.6.3

sorting NULL values, 7.5

specifying data store size, 9.1.2

SQL

query plan, 10.3.1

tuning and performance, 9.3

SQLPrepare, 10.3.1

and execution plan generation, 10.4.2

performance impact, 9.3.9

sqlquerytimeout ttIsql command, 6.7

SQLTransact

undoing effects, 8.2

starting and stopping the Server, 2.4

starting and stopping the TimesTen Data Manager, 3.1

starting the daemon

on UNIX, 3.2

on Windows, 3.1

starting the Data Manager Service, 3.1

static checkpoints, definition

statistics

computing, 9.3.5

recomputation, 10.1

ttOptEstimateStats, 9.3.5

ttOptUpdateStats, 9.3.5

STEP column in PLAN table, 10.3.1.3.1

stopping the daemon

on UNIX, 3.2

on Windows, 3.1

stopping the Data Manager Service, 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

synchronous checkpoints

See static checkpoints

SYS owner of tables, 7.2.1.4

syslog, 3.4.2

SYS.MONITOR table, 1.6.2.3, 9.5.2, 9.8.1

System DSN, 1.3.1, 2.8.5, 2.8.7

system failure

resulting logs and locks, 8.2

system privilege

overview, 4.2.1.1

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

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

estimating size, 7.2.2.3

table size

estimating, 7.2.2.3

ttSize utility, 7.2.2.3

table-level locks, 8.5.2

tables

adding rows, 1.8

creating, example, 7.2.2.1

deleting rows, 7.6.2

dropping, example, 7.2.2.2, 7.4.2.2

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.2.1

Temporary attribute

performance, 9.1.4, 9.1.5

temporary data partition

and replication, 1.6.2.1

temporary data store

logging, 7.1.3

TempSize attribute, 1.6.1, 1.6.2

monitoring, 1.6.2.3

specifying, 9.1.2

testing connections on Windows, 2.8.7

thread programming

and TimesTen, 1.2.4

time-based aging, 7.2.3.2

timeout interval

setting on Windows, 2.8.4

TimesTen

ODBC driver, 1.1.1

thread programming, 1.2.4

TimesTen daemon

options, 3.4

TimesTen Server daemon, 3.5.1

TIMESTEN8 character set, 5.7.1

timestend, 3

timing ODBC function calls, 6.14

transaction commit

logs and locks, 8.2

transaction management

isolation levels, 8

locking, 8.2

logging, 8.2

semantics, 8.2

transaction rollback

logs and locks, 8.2

performance impact, 9.5.5

transactions

durable commit, 9.5.1

locking, 9.2.3

performance, 9.5.1, 9.5.2

sizing, 9.5.1

XLA, 9.8.1

tryhash ttIsql command, 6.13

trymergejoin ttIsql command, 6.13

trynestedloopjoin ttIsql command, 6.13

tryrowid ttIsql command, 6.13

tryserial ttIsql command, 6.13

trytbllocks ttIsql command, 6.13

trytmphash ttIsql command, 6.13

trytmptable ttIsql command, 6.13

trytmpttree ttIsql command, 6.13

tryttree ttIsql command, 6.13

TT_PREFETCH_CLOSE connection option, 9.2.5

ttAgingLRUConfig built-in procedure, 7.2.3.1

ttBlockInfo utility, 1.6.2.3

ttconnect.ini file, 2.11

ttdaemon.options file

changing, 3.4

ttDurableCommit, 8.4

ttDurableCommit procedure, 9.5.2

ttendaemon.options file, 3.4, 3.4.2, 3.4.2, 3.4.3, 3.5.5

ttIsql, 6.3

built-in command usage, 6.7, 6.8, 6.8, 6.8, 6.13, 6.14, 6.15

clearing command history, 6.5.1

command history, 6.5

customizing command prompt, 6.2

deleting rows, 7.6.2

displaying data store information, 6.8

editline feature, 6.4

modes, interactive and batch, 6.1

online help, 6.3

saving command history, 6.5.1

timing ODBC function calls, 6.14

using, 6

using OUT parameters, 6.10

view and set data store attributes, 6.12

viewing optimizer plan, 6.13

working with character sets, 6.6

working with parameterized SQL statements, 6.15

working with prepared SQL statements, 6.15

working with transactions, 6.7

TTISQL environment variable, 6.16

ttLocalHost

logical server address, 2.2.3

ttmodinstall utility, 3.4

ttOptClearStats built-in procedure, 10.4.3

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.11.1

logical server address, 2.2.2

ttSize utility, 1.6.2.1

ttStatus utility, 1.6.2.2

ttWarnOnLowMemory procedure, 1.6.3

U

unique indexes, 7.5

V

Versioning, 8.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.15

prepared SQL statements, 6.15

X

XLA

bookmark, deleting, 6.17

performance, 9.8.1

privilege, 4.2.2.4

updates

acknowledging, 9.8.3

xlabookmarkdelete ttIsql command, 6.17