Is it possible to see the results of Update Statistics in an 
Author Message
 Is it possible to see the results of Update Statistics in an

Hi everybody,
    Is there any SMI table which will tell you the status of the last update
statistics run on a particular table ? When I say status, I mean stuff like the
"date" it was last run, maybe the kind of update statistics ( high/medium/low ).
Or am I wishing for the moon ??

Sujata

********************************************************************************
******************************
*   Sujata Soman                                                                
                                               *

                                     *
*   Database Administrator ( Informix )                                        
                                        *
*   O'Melveny & Myers, Los Angeles                                              
                                     *
********************************************************************************
******************************



Wed, 18 Jun 1902 08:00:00 GMT
 Is it possible to see the results of Update Statistics in an

Quote:

> Hi everybody,
>     Is there any SMI table which will tell you the status of the last update
> statistics run on a particular table ? When I say status, I mean stuff like the
> "date" it was last run, maybe the kind of update statistics ( high/medium/low ).
> Or am I wishing for the moon ??

For some reason this posting just showed up for me today.  On the off
chance that noone replied before the table you are looking for is
sysdistrib in each database.  You can see its columns in dbaccess/isql
[TABLE][INFO]sysdistrib

Art S. Kagel



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Performance Issues with UPDATE STATISTICS WITH FULLSCAN on _WA_Sys auto statistics

2. Why am I seeing such frequent registry access

3. Why am I not seeing deadlock messages in my Error Log

4. ANNOUNCE: Another update statistics utility - latest update

5. An update statistics program - updated version for you

6. seeing cursor result set

7. Is this Possible Using DTS?Could you say the details.I am new

8. Is this possible, or am I pushing it?

9. Retrieve index statistics (estimated results for search term)?

10. Help... float data resulting in inaccurate statistics :(

11. Statistics IO results

12. Strange results with Oracle 8.1.7 and statistic gathering dbms_stats vs dbms_utility


 
Powered by phpBB® Forum Software