Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    218

    Unanswered: recompute statistics in sql*server via JDBC

    We are inserting huge amount of data (could be several millions) during a fact upload. Therefore after the upload we recomputed the statistics. In oracle this can be done using the following sql statement:

    analyze table <table_name> compute statistics

    Do you know if there is any equivalent statement in SQL*Server? it has to run via JDBC like a SQL statement.

    Thanks.

  2. #2
    Join Date
    Jun 2003
    Posts
    269

    Thumbs up

    check UPDATE STATISTICS in Sql Server Books online
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

Posting Permissions

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