CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Interview Success Kit - 9,000 Interview Que. & Ans.
Covers 9,000+ Interview Questions asked in actual MNC Interviews - all with model answers.
Get Your Dream Job Now - www.vyoms.com
Sponsored Links
Interview Questions
Our Services

INTERVIEW QUESTIONS DATABASE SYBASE DETAILS
Question :
Explain What is Update Statistics?
Category Sybase Interview Questions
Rating (3.0) By 5 users
Added on 4/3/2013
Views 651
Rate it!
Answers:

The update statistics command helps the server make the best decisions about which indexes to use when it processes a query, by providing information about the distribution of the key values in the indexes. The update statistics commands create statistics, if there are no statistics for a particular column, or replaces existing statistics if they already exist. The statistics are stored in the system tables systabstats and sysstatistics.



If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-

  • There should not be any Spelling Mistakes.
  • There should not be any Gramatical Errors.
  • Answers must not contain any bad words.
  • Answers should not be the repeat of same answer, already approved.
  • Answer should be complete in itself.
  • Name :*
    Email Id :*
    Answer :*
    Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
    Process Verification Enter the above shown code: *
    Inform me about updated answers to this question

    Related Questions
    View Answer

    Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

    View ALL Sybase Interview Questions & Answers

    User Options
    Latest 20 Questions
    On what basis you can arrive to an estimation for your project?
    How will you conduct Risk Analysis?
    Explain what is Test Deliverables ?
    What are the valuable steps to resolve issues while testing?
    What are the tables in testplans?
    Why we split testing into distinct stages?
    What is black box testing? What are the different black box testing techniques?
    What are the Experience-based testing techniques ?
    What are the phases of a formal review?
    Which of the following are valid objectives for incident reports?
    What are the different Methodologies in Agile Development Model?
    What is component testing?
    What is the difference between Testing Techniques and Testing Tools?
    When is used Decision table testing?
    Mention what are the different types of variables?
    How to create the operation mode?
    What are R/3 Basis configurations?
    What are the roll and page areas?
    What are the functions of dispatcher?
    What are the different types of locators in Selenium?


    Copyright ©2003-2016 CoolInterview.com, All Rights Reserved.
    Privacy Policy | Terms and Conditions

    Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Dedicated Servers | C Interview Questions & Answers

    Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes


    Cache = 0.947266 Seconds