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 happens if the update subquery returns multiple rows in ms sql server?

0 Answers  

How to connect PK and FK?

2 Answers  

What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,

How to count groups returned with the group by clause in ms sql server?

0 Answers  

What is the security model used in sql server 2005?

0 Answers  

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

How do I open port 1433?

0 Answers  

Get Current System Date Time

2 Answers  

can we call functions from stored procedure in SQL Server 2005 ? How?

3 Answers  

What is the difference between coalesce() & isnull()?

0 Answers  

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

0 Answers  

What is Inner Join?

2 Answers  

For more SQL Server Interview Questions Click Here
Categories