Professional Web Applications Themes

Statistics updates ... - Microsoft SQL / MS SQL Server

If a schema change is made to tables, does the temporarily cause any extra work vis-a-vis the statistics kept by the server? Thanks, Bob Castleman SuccessWare Software...

  1. #1

    Default Statistics updates ...

    If a schema change is made to tables, does the temporarily cause any extra
    work vis-a-vis the statistics kept by the server?

    Thanks,

    Bob Castleman
    SuccessWare Software


    Bob Guest

  2. #2

    Default Re: Statistics updates ...

    In some cases, yes. Since the schema changes can affect the columns &
    possibly if the key values are altered the statistics does not match with
    the indexing keys. In such cases you'll have to do an UPDATE STATISTICS to
    keep the statistics up to date.

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Guest

  3. #3

    Default Re: Statistics updates ...

    So if we did a DROP INDEX/ADD INDEX (we changed a non-clustered to a
    clustered index) we should also have done an UPDATE STATISTICS?
    "Anith Sen" <com> wrote in message
    news:phx.gbl... 


    Bob Guest

  4. #4

    Default Re: Statistics updates ...

    Also if you have auto statistics set to on you do not have to do this
    explicitly, since the recreation of the indexes force the statistics to be
    up to date (out-of-date statistics are automatically rebuilt during
    optimization). You can use sp_dboption or sp_autostats on a specific table
    to set the automatic UPDATE STATISTICS setting. Refer to SQL Server Books
    Online for more details on syntax and associated information.

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Guest

Similar Threads

  1. web statistics...
    By Bill in forum Macromedia Flash Sitedesign
    Replies: 4
    Last Post: December 27th, 02:47 PM
  2. how to imp statistics from 8i to 9i db
    By G in forum Oracle Server
    Replies: 0
    Last Post: October 15th, 11:04 PM
  3. Statistics
    By TS in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 18th, 11:12 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139