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

How do I run a trace in sql server?

0 Answers  

what is victor class

0 Answers  

What is msdb database? : SQL Server Architecture

0 Answers  

What are the system database in sql server 2005?

0 Answers  

What are the differences between lost updates and uncommitted dependencies?

0 Answers  

What do you mean by table and field in sql?

0 Answers  

Which Model uses the SET concept

0 Answers   Infosys,

SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES

1 Answers   Microsoft,

What is stored procedure in SQL..??

2 Answers  

What is acid db?

0 Answers  

What is an active database?

0 Answers   HCL,

Do you know the capabilities of cursors?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories