Timesten - Statistics

> Database > (TimesTen|TT) (In-Memory Database|IMDB)

1 - About

Information about statistics structure (table, index,…)

2 - Management

2.1 - Metadata

Example: Stale statistics

SELECT
  tstats.*,
  TABLES.*
FROM
  SYS.TABLES TABLES,
  TBL_STATS tstats
WHERE
  TABLES.tblid = tstats.tblid (+)
AND
  (
    laststatsupdate IS NULL
  OR to_date(UPPER(SUBSTR(laststatsupdate,5)),'MON DD HH24:MI:SS YYYY') < sysdate - 7
  )
AND TABLES.TBLOWNER <> 'SYS'
Advertising

2.2 - Update

procedure: ttOptUpdateStats