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 is change tracking in sql server?

0 Answers  

Explain sql server authentication modes?

0 Answers  

Does group by or order by come first?

0 Answers  

What is data file in computer?

0 Answers  

What is a join in sql?

0 Answers  




explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

how to get the salary in descending order with out using the keyword desc in sql

5 Answers   Ramco,

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

0 Answers  

What is blocking and how would you troubleshoot it?

3 Answers   HCL,

How to write a query with a right outer join in ms sql server?

0 Answers  

Is candidate a key?

0 Answers  

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

For more SQL Server Interview Questions Click Here
Categories