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 are xml indexes?

0 Answers  

Please differentiate between a local and a global temporary table?

0 Answers  

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

Can we call future method from trigger?

0 Answers  

What are the differences between lost updates and uncommitted dependencies?

0 Answers  

What is the use of set nocount on/off statement?

0 Answers  

I have to display ten columns values from diffrent ten tables. how many joins are require?

10 Answers   CarrizalSoft Technologies, HCL,

How to list all dsn entries on your local machine using odbc_data_source()?

0 Answers  

What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,

What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,

What does COMMIT command do?

0 Answers   Amdocs,

What is database black box testing?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories