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

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

0 Answers  

What are synonyms?

0 Answers  

What are the basic functions for master, msdb, model, tempdb and resource databases?

0 Answers  

What is difference between materialized view and view?

0 Answers  

what is a traditional network library for sql servers? : Sql server database administration

0 Answers  

What do you mean by subquery?

0 Answers  

what is denormalization? : Sql server database administration

0 Answers  

To find second largest salary in Employee table

17 Answers   CSS,

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

Describe triggers features and limitations?

0 Answers  

Difference between aggregate functions of sql?

0 Answers   EXL,

What is collation?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories