Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    15

    Unanswered: Index statistics

    How to find when the last update of Index statistics is done for a particular table?

    Fyi, I dont have dba access to that database.

    TIA,
    Sankar

  2. #2
    Join Date
    Sep 2003
    Location
    London
    Posts
    12

    Re: Index statistics

    The following query gives this info, but I don't think you will be able to run it without sa_role.

    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 colid = convert(tinyint,substring(colidarray,1,1))
    AND s.id >100
    AND s.c4 != null
    AND s.c5 != null
    ORDER by 1,2
    Will

  3. #3
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    or reading the header of the output file of optdiag

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •