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

What is always encrypted?

0 Answers  

How is sql server used?

0 Answers  

What are different types of data sources?

0 Answers  

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,

What are the new features in SQL Server 2005?

3 Answers   Emphasis,

Explain subquery and state its properties?

0 Answers  

What functions can a view be used to performed?

0 Answers  

What is inline table-value user-defined function?

0 Answers  

What is plan freezing?

0 Answers  

how we can store the value like that 001,003,023 etc in sql server 2005

7 Answers  

For more SQL Server Interview Questions Click Here
Categories