Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 difference between table aliases and column aliases? Do they affect performance?

0 Answers  

Which table keeps information about stored procedures?

0 Answers  

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers   TVS,

What is service broker?

0 Answers  

What are system databases into sql server (2005/2008)?

0 Answers  

What is an example of a foreign key?

0 Answers  

What do you understand by the data quality services in sql server?

0 Answers  

Explain collation?

0 Answers  

Security Question- SQL DBA exparts, need your help...

3 Answers  

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

11 Answers   World Tech, Yardi Software,

Explain syntax for dropping triggers?

0 Answers  

How do I setup a sql server database?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories