I have a table that there are a lot of accessing operations to it, include: select, insert, update, delete. My table has 80 columns, about 1M rows, one primary key (2 cols), 5 indexes in other cols.
I want to increase select speed.
Should I use TimesTen Cache for this table? Which cachegroup type (read-only, awt, swt,...) I should use?