diffrence between estimate statistics and compute statistics
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: diffrence between estimate statistics and compute statistics

Hybrid View

  1. #1
    Join Date
    Oct 2001
    Location
    Calcutta , India
    Posts
    78

    Question diffrence between estimate statistics and compute statistics

    Hi all,

    What is the difference between

    analyze table compute statistics

    and

    analyze table estimate statistics ?

    What is the default % (60% or 70% or 25% or ? ) in the second
    case?

    Deba

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    defualt for estimate is 1064 rows as sample if you omit it.

    Compute : 100% ( all rows )


    RTM
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Compute : Computes Statistics for whole Table(for all rows).

    Estimate: - Computes Statistics on sample of rows over the table.
    - Be default, its 1064 rows.
    - You can specify rows in numbers or in percentage of total rows.
    - If the number or percentage of rows exceeds 50%, Statistics will be computed on all rows in Table.

    HTH.
    -- Dilip

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    also, you should be using DBMS_STATS instead of the analyze command.

    you can also get the option of sampling by % of rows or by % of blocks.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

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



Click Here to Expand Forum to Full Width