'update statistics' Tag

• Check des letzten update statistics Durchlaufes

  Juni 26, 2009

  SELECT object_name(s.id) tablename,
  c.name column_name,
  convert(int,c4)actual_steps,
  convert(int,c5)requested_steps,
  moddate last_updated
  FROM sysstatistics s,syscolumns c
  WHERE formatid=100
  – AND s.id = object_id("TABLE_NAME")
  AND s.id=c.id
  AND s.id >100
  AND s.c4 != NULL
  AND s.c5 != NULL
  ORDER BY 1,2

  posted in ase by fm