I set data aging for this table, so number of rows of this table always about 800k rows2. How often do you update optimiser statistics for this table and what call do you use to do so?
I run 2 times/ a day3. Have you checked the plans for the queries executed in TimesTen (use explain command in ttIsql)? Do the plans look good?
I've checked, my query uses indexes in query plan.I'm also curious as to why you use a java process to synchronise data from oracle to TimesTen rather than using e.g. a READONLY cache group in TimesTen.
(I wonder why the first time I create table, load full data from Oracle, accessing operation (insert, update,...) is quite fast; however, after 2-3 days, accessing speed slower. Is data aging the cause?
My Oracle DB use characterset that TimesTen doesn't supportAny suggestions for me?