8 Working with Data in a TimesTen Database

There is detailed information on the basic objects in a TimesTen database and simple examples of how you can use SQL to manage these objects.

For more information about SQL, see Data Types in the Oracle TimesTen In-Memory Database SQL Reference.

For information on how to issue SQL from within an application, see the appropriate TimesTen developer's guide.

This chapter includes the following topics:

• Database Objects, Users and Owners

• Understanding Tables

• Understanding Views

• Understanding Materialized Views

• Understanding Indexes

• Using the Index Advisor to Recommend Indexes

• Understanding Rows

• Understanding Synonyms

• Understanding System Views