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 is b tree index?

0 Answers  

application server is slow what may be the problem

0 Answers   Microsoft,

When would you use the stored procedures or functions?

0 Answers  

What is cursors?

0 Answers   NA,

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

what is mean by crystal repoart? ahere we will mainly use that?

1 Answers  

List the different types of joins?

0 Answers  

How to execute stored procedure and set temp table in sql server?

0 Answers  

What is set nocount on and what is set nocount off?

0 Answers  

What is the maximum size of a row in sql server?

0 Answers  

What is Check point? Explain in Brief what it will do?

1 Answers   Wipro,

how to determine the service pack currently installed on sql server? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories