Sunday, 24 November 2013

Disadvantage of index?




  1. Every index increases the time in takes to perform INSERTS, UPDATES and DELETES, so the number of indexes should not be very much.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • ASP.NET MULTIPLE CHOICE QUESTIONS
    ASP.NET QUESTIONS 1) On which of the operating system below ASP.NET can run?             a)   Windows XP Professional      ...
  • Index Optimization tips
    T-SQL Queries 2 tables Employee Phone empid empname salary mgrid empid phnumber Select all employees...
  • DOT NET MCQ QUESTIONS PART5
    76) Select the control which does not have any visible interface                a) Datalist                b) DropdownList          ...
  • DOTNET MNC TECHNICAL INTERVIEW PART 1
    1. What is a Web service ? How it is different from remoting? 2. Diiferent life cycle events phases in asp.net web form. 3. OOPS conc...
  • ASP DOTNET MCQ QUESTIONS PART3
    56) Which of the following is true ?                a) IsPostBack is a method of System.UI.Web.Page class                 b) IsPostBa...
  • Interview Questions .NET Windows Forms
    Interview Questions .NET Windows Forms 1)   Write a simple Windows Forms MessageBox statement? 2)   Can you write a class witho...
  • ASP DOTNET MCQ QUESTIONS PART 9
    126) Which of the following denote ways to manage state in an ASP.Net Application?               a) Session objects               b)...
  • Asp.net Page Life cycle
    Asp.net Page Life cycle This is a transcript of a  programming manual, to refresh my memory, and it’s always good to RTFM. As a contro...
  • DOTNET MNC TECHNICAL INTERVIEW QUESTIONS PART 2
    1. What is caching.? 2. Types of cahing? 3. What is cache Block? 4. What are indexers? 5. What is difference between Namespace and assembl...
  • ASP DOTNET MULTIPLE CHOICE QUESTIONS PART 1
    21) To set page title dynamically in ASP.NET which of the following is used ?                a) None of the above                b) ...