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

Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not?

Question Posted / vanitha.s

Answers were Sorted based on User's Feedback



Would it be a good idea to create an index on a table that always contains 10 records? Why or why ..

Answer / bharathi

No it is not a good idea. Indexes are very expensive to
maintain. Indexes are created mainly to improve performace.
If there are only 10 rows in a table, creating index would
not make any difference in the performace.

Is This Answer Correct ?    5 Yes 0 No

Would it be a good idea to create an index on a table that always contains 10 records? Why or why ..

Answer / laxman

Not a good idea.

Indexes are used for improve select query performance.
indexes will be useful when the data is more and more.

Is This Answer Correct ?    3 Yes 0 No

Would it be a good idea to create an index on a table that always contains 10 records? Why or why ..

Answer / subhash

No it's not a good idea.

Table scan would be fine for smaller tables with less records. Moreover indexes need disk space. It's not necessary to create an index and waste the disk space.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are explicit and implicit transactions?

4 Answers   BirlaSoft,

What are the different types of backup avaible in SQL SErver

6 Answers   Emphasis, IBM,

List out the difference between union and union all in sql server?

0 Answers  

Can we call SP inside a query?

5 Answers   CA, CarrizalSoft Technologies, Wipro,

What is lock escalation and what is its purpose?

0 Answers  

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

What is change data capture (cdc) in sql server 2008?

0 Answers  

How do we rollback the table data in SQL Server

3 Answers  

hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn

0 Answers  

Can you explain what are commit and rollback in sql?

0 Answers  

How to find tables without indexes?

0 Answers  

Name three version of sql server 2000 and also their differences?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories