SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 363 Page Views: 

There are several advantages of creating and index , but can you state some drawbacks of creating an index?



Posted By: Avi Date: 1 October 2010 11:10:07 AM
 Answer:

There are major two drawbacks of using indexes. 1.First one is the disk space. Index uses much space or infact the double the space of the actual database. 2. Second one is during modifiaction of data. Whenever any modifications are to be done such as, insertion,deletion or updation the rows are modified quickly due to indexes which is plus point. But problem is that after modification the databse has to update all the indexes which was using that data. So indexes are much beneficial in those cases when the data is static or very less modification are required.


Posted By: avibtech

Date: 1 October 2010 11:10:07 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image fGI5vI
Related Questions
SQL Server : What will be the result of the following query ? Explain your answer. create table tempo (sno INT, item_code nvarchar(2)) ; insert into tempo select 1, '0' UNION select 2, '11' UNION select 3, '12' UNION select 4,'0' UNION select 5,'0' update t

What will be the result of the following query ? Explain your answer. create table tempo (sno INT,....

The given query will result inot 3 rows. Sno item_code 1 4 5 ....
Category: SQL Server Date: 10/1/2010 11:38:07 AM
SQL Server : What is the purpose of sp_lock?

What is the purpose of sp_lock?

sp_lock is a stored procedure which returns the detailed information regarding the locks. The follow....
Category: SQL Server Date: 10/1/2010 11:37:07 AM
SQL Server : Define Phantom?

Define Phantom?

From SQL Server Online Books Phantom is defined as:- Phantom behavior occurs when a transaction att....
Category: SQL Server Date: 10/1/2010 11:36:07 AM
SQL Server : What does OBJECT_ID specifies?

What does OBJECT_ID specifies?

Object_ID is the option used in the SELECT statement which returns the object's idebtification numbe....
Category: SQL Server Date: 10/1/2010 11:35:07 AM
SQL Server : How can you get the accurate count of the records in a table?

How can you get the accurate count of the records in a table?

There are several ways of getting/retreiving the accurate records count from the table. Following Sy....
Category: SQL Server Date: 10/1/2010 11:34:07 AM
 
Signup for our weekly email newsletter
email newsletter
Questions Categories