• Hi there

    I believe they do, especially if the so called "parameter sniffing" feature of sqlserver is still around. Run something like this for example:

    DBCC SHOW_STATISTICS (mytable, PK_MyPrimaryKey)

    this returns info similar to what I would expect for disribution statistics with a date of the refresh.

    Cheers

    Chris K


    Chris Kempster
    www.chriskempster.com
    Author of "SQL Server Backup, Recovery & Troubleshooting"
    Author of "SQL Server 2k for the Oracle DBA"