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

What is a table called, if it does not have neither Cluster
nor Non-cluster Index?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is a table called, if it does not have neither Cluster nor Non-cluster Index?..

Answer / gurudatt nayak

it is called as a heap table

Is This Answer Correct ?    15 Yes 2 No

What is a table called, if it does not have neither Cluster nor Non-cluster Index?..

Answer / debasish nanda

Unindexed table or Heap. Microsoft Press Books and Book on
Line (BOL) refers it as Heap. A heap is a table that does
not have a clustered index and, therefore, the pages are not
linked by pointers. The IAM pages are the only structures
that link the pages in a table together. Unindexed tables
are good for fast storing of data. Many times it is better
to drop all indexes from table and then do bulk of inserts
and to restore those indexes after that.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

What is the template in sql?

0 Answers  

What is normalization according to you and explain its different levels?

0 Answers  

What are the diifferences between the ms sql server vs mysql?

0 Answers  

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

0 Answers  

What are various aggregate functions that are available?

0 Answers  

what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  

Explain what stored procedure sp_replcounters is used for? : sql server replication

0 Answers  

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

How send email from database?.

3 Answers   CarrizalSoft Technologies, Merrill Lynch,

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

What is filter index?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories