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

Can you leave a union at any time?

0 Answers  

Why olap is used?

0 Answers  

What part does database design plays a role in performance of an sql server-based application?

0 Answers  

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  

Which joins are sql server default?

0 Answers  

how we can store the value like that 001,003,023 etc in sql server 2005

7 Answers  

How secure is sql server database?

0 Answers  

Define right outer join in sql server joins?

0 Answers  

How can you check the level of fragmentation on a table?

0 Answers  

How to provide values to user defined function parameters?

0 Answers  

What are the benefits and tasks of object explorer? : sql server management studio

0 Answers  

Can coalesce return null?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories