About ttIsql

You can use the ttIsql command line interface to issue SQL statements and built-in ttIsql commands to perform various operations.

Some common tasks that are accomplished using ttIsql include:

• Set up and maintain databases: You can create tables and indexes, alter existing tables, and update table statistics quickly and easily using ttIsql.
• Connection setup: You can connect or disconnect to the TimesTen and Oracle databases.
• Retrieve information on database structures: You can retrieve the definitions for tables, indexes, and cache groups using built-in ttIsql commands. In addition, the current size and state of the database can be displayed.
• Run and optimize database operations: You can use the ttIsql utility to run, alter, and display query optimizer plans for the purpose of tuning SQL operations. The time required to run various ODBC function calls can also be displayed.