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 relationships and mention different types of relationships in the dbms

0 Answers  

How does normalization work?

0 Answers  

Explain throw statement in sql server 2008?

0 Answers  

What are the elements of dbms?

0 Answers  

How many types of built in functions are there in sql server 2012?

0 Answers  

What are the four main query statements?

7 Answers   Wipro,

What are the events recorded in a transaction log?

0 Answers  

What are the grouping functions?

0 Answers  

What is dbcc command in sql server?

0 Answers  

Explain user defined views?

0 Answers  

What is sql server query analyzer?

0 Answers  

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

For more SQL Server Interview Questions Click Here
Categories