7 Using SQL in TimesTen Scaleout

Applications use SQL and PL/SQL to access data in a database in TimesTen Scaleout. This topic describes how to use SQL to work with databases in TimesTen Scaleout.

• Overview of SQL

• Overview of PL/SQL

• Working with Tables

• Altering Tables

• Understanding Indexes

• Using Sequences

• Performing DML Operations

• Using Pseudocolumns

• Using the TT_CommitDMLOnSuccess Hint

• Using Optimizer Hints

• Understanding ROWID in Data Distribution

• Understanding System Views