Update statistics
Why would "update statistics drop distributions" take several hours.....? And it is still running.... I would have assumed that this would just basically be a delete in the sys tables. Am I wrong? Please do not transmit orders or instructions regarding a UBS account by email. The information provided in this email or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your email. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you. UBS Financial Services Inc. UBS International Inc.
If you are running a DSS system with huge amount of data then it will take a long time because it has to delete all distributed bins and then recreate them brand new when the new updating of the stats take place. You should drop distributions on DSS system, only if you are sure that you have enough time to recreate them back. Hope this helps. Ravi. "Zablatzky, ...." <Wayne.Zablatzky@ubs.com> wrote: Why would "update statistics drop distributions" take several hours.....? And it is still running.... I would have assumed that this would just basically be a delete in the sys tables. Am I wrong? Please do not transmit orders or instructions regarding a UBS account by email. The information provided in this email or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your email. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you. UBS Financial Services Inc. UBS International Inc. --------------------------------- Do you Yahoo!? Yahoo! Small Business - Try our new resources site!