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 / subhash

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is the purpose of sql profiler in sql server?

1079

How can we migrate from SQL server to SQL Azure?

113

What is coalesce in sql server?

1057

Explain multiserver query

1048

What is the difference between char, varchar and nvarchar?

1024

Explain what is the use of custom fields in report?

929

Explain about remote stored procedure?

1012

Explain “@@rowcount” and “@@error” in sql server?

1095

Define left outer join in sql server joins?

969

Distinguish between commit and rollback?

967

How to create dbo table in sql server?

957

What are the filtered indexes?

1040

What stored by the msdb?

1003

What is inline variable assignment?

1032

What is sql injection? How to protect against sql injection attack?

1002