You are not logged in or registered. Please login or register to use the full functionality of this Website SybaseTeam.Com...
Hello There, Guest! (LoginRegister) Remember Me? Current time: 12-18-2014, 08:22 AM
   Home  |  About Us  |  Sybase Training  |  Synergy  |  Consulting  |  Job Openings  |  Tech Videos  |  Rules and Disclaimer  |  Search
Post Reply 
Forum Tools
What happens exactly, when the UPDATE STATISTICS is run on table ?
11-15-2011, 09:44 PM
Post: #7
Quote this message in a reply
RE: What happens exactly, when the update statistics is run on table ?


    (11-12-2011 05:41 AM)Sybase123 Wrote:  It is really good for me, Now i can understand clearly what is happening while run update statistics on table.

    Please help me as like this on DBCC commands... (pls provide doc as like this)

I have started a new thread for the new question.



Ashirvad to my Shishyas, Cheers to the others
Derek Asirvadem
Information Architect / Sr Sybase DBA
Website
Selection of Useful Documents for the Sybase DBA
Visit this user's website Find all posts by this user
08-26-2013, 05:22 AM
Post: #8
Quote this message in a reply
RE: What happens exactly, when the UPDATE STATISTICS is run on table ?


Hi,

Kindly suggest me, what problem occurs when I explicitly killed update statistics command.

And also suggest, how many processes are wake up for a single database while running update statistics command, in my case it will start 4 to 5 processes for single database.

Waiting for your reply...

Thank you
Sagar Akhare


Find all posts by this user
Post Reply 


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  Multiple update eldeleon 0 1,440 07-02-2012 06:09 PM
Last Post: eldeleon
  Missing rows in result set with concurrent update with datarows locking scheme arvincloane 1 1,793 05-17-2012 07:14 AM
Last Post: bitla
  how to check the existence of the temporary table sruthi 5 5,061 11-10-2011 11:53 AM
Last Post: DerekAsirvadem
  Transfer Table Utility atish.deshmukh 1 2,736 01-27-2011 10:48 AM
Last Post: piyushpathak_2000
  Internal representation of #temp table names in sybase ase 15 server Nagendra 0 2,952 07-22-2009 03:01 AM
Last Post: Nagendra

Options:
Forum Jump:


Contact Us | SybaseTeam | Disclaimer & Rules | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication