Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: Oracle's Analyze Table statement ?

    Hi,

    Below is an Oracle query used for cost optimization purpose :

    analyze table test estimate statistics sample 2500 Rows;

    Is there any equivalent for the above in SQL Server ?

    Please advice,

    Thanks,
    Sam

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Why look for equivalent? Just convert to it!
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    microsoft sql server automatically updates statistics as a default setting
    you wouldnt have to manually create statistics unless you chose exceptions to the norm in your design.

    for example
    turning off autoupdatestats
    creating composite indexes and creating statistics on the non leading columns
    creating statistics on commonly searched columns that wouldnt normally warrant an index.

    you can run the create statistics statement or the update statistics statements respectively

    Check out Books Online in your SQL Server start menu folder
    and search for statistics create stats or update stats.

  4. #4
    Join Date
    Mar 2004
    Posts
    205
    Below is an Oracle query used for cost optimization :

    analyze table Customer list chained rows into CHAINED_ROWS;

    Is there any equivalent for the above in SQL Server ?

    Please advice,

    Thanks,
    Sam

  5. #5
    Join Date
    Oct 2004
    Posts
    15

    Question

    Is there any solutions?
    I too need the equivalent for
    the above query.

    any help would be appreciated

    With Regards
    Sathya

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    MS-SQL does not need the kind of maintenance that Oracle needs. It used to, years ago, but that time is long gone.

    I could make up a number of suggestions, some of which would actually do something to improve optimization a bit, others would just do some disk i/o and make you feel good, but none of them are really needed anymore.

    -PatP

Posting Permissions

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