Estimating the Size of an Index

Increasing the size of a TimesTen database can be done on first connect. Use the ttSize utility to estimate database size, including any indexes.

Correctly estimating the size of a database helps you to avoid having to resize the database in the future.

The following example shows that the ttSize utility estimates the rows, inline row bytes, size of any indexes on the table, and the total size of the table:

% ttSize -tbl pat.tab1 mydb

Rows = 2

Total in-line row bytes = 17524
Indexes:

 Index PAT adds 6282 bytes
  Total index bytes = 6282

Total = 23806