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?
Sure you could use TimesTen to cache this table from the Oracle database. As you are performing DML against it I would recommend you look at the Asynchronous Write-Through (AWT) Cache Group.
Start here -> http://docs.oracle.com/cd/E21901_01/doc/timesten.1122/e21634/concepts.htm#BABFBIEC
Info on AWT -> http://docs.oracle.com/cd/E21901_01/doc/timesten.1122/e21634/define.htm#CHDJAJAC