1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the disadvantages of index?

Question Posted / naren

Answers were Sorted based on User's Feedback



What is the disadvantages of index?..

Answer / suresh babu

We can create more number of indexes for a table.It required
separate memory space for each and every index.It will be
fast when using the search condition.

But if we are going to do some DML operations such as
insert,update,delete the server performance should reduce.

Is This Answer Correct ?    25 Yes 3 No

What is the disadvantages of index?..

Answer / naren

it will allocate more space on disk.

Is This Answer Correct ?    15 Yes 2 No

What is the disadvantages of index?..

Answer / guest

index reduce server preformance

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What are scheduled tasks in sql server?

0 Answers  

Is natural join and equi join same?

0 Answers  

How to install sql server 2005 express edition?

0 Answers  

How can we rewrite sub-queries into simple select statements or with joins?

0 Answers  

What happens if null values are involved in string operations?

0 Answers  




How to view the error log for any specific instance? : sql server database administration

0 Answers  

What is indexing explain it with an example?

0 Answers  

Explain the difference between clustered and non-clustered index?

0 Answers  

what are constraints? Explain different types of constraints? : Sql server database administration

0 Answers  

What does select 1 mean?

0 Answers  

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

How can we check the sql server version?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories