DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: compute statistics

  1. 05-08-2001, 10:48 PM #1
    ckwan
    ckwan is offline Senior Member
    Join Date
    Oct 2000
    Posts
    250
    Does anyone successfully ran the analyze table compute statistics command ? Anyone can share the experience on this ? Thanks.
    Reply With Quote Reply With Quote
  2. 05-08-2001, 11:21 PM #2
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Any problem ? I did use it and didn't find any problems in using that command. I did use it Just before posting this. Any Specific Problem ?
    Reddy,Sam
    Reply With Quote Reply With Quote
  3. 05-08-2001, 11:26 PM #3
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    just a word of caution dont ever try to analyze objects owned by user sys or system.......
    Reply With Quote Reply With Quote
  4. 05-09-2001, 03:21 AM #4
    ckwan
    ckwan is offline Senior Member
    Join Date
    Oct 2000
    Posts
    250
    How to view the computed statistics ? Thanks
    Reply With Quote Reply With Quote
  5. 05-09-2001, 03:27 AM #5
    bmycroft
    bmycroft is offline Member
    Join Date
    Sep 2000
    Posts
    193

    To view the stats

    desc dba_tables, dba_indexes etc and the stats are there to a certain extent - including 'Last_Analysed' which you can use to check if your stats are up to date.

    -Bob
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width