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

Why SQL Agent is used?

0 Answers   Abacus,

How do I install sql server?

0 Answers  

What is the cpu pressure?

0 Answers  

What are logical/boolean operations in ms sql server?

0 Answers  

Explain about merge replications?

0 Answers  

How to concatenate two binary strings together?

0 Answers  

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

What do you mean by subquery?

0 Answers  

What is the meaning of sql server?

0 Answers  

What is dbcc?

0 Answers  

What is single-user mode?

0 Answers  

What are built in functions?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories