What is a table called, if it does not have neither Cluster
nor Non-cluster Index?
Answers were Sorted based on User's Feedback
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 |
Can you explain what is the use of custom fields in report?
Which is better statement or preparedstatement?
How fixed length strings are truncated and padded?
How do you manipulate data?
What does sql server mean?
List the different index configurations possible for a table?
Tell me about joins in database system and explain each in detail.
0 Answers Axtria, ITC Indian Tobacco Company,
What is usually the first word in a sql query?
Explain indexing and what are the advantages of it?
Explain the microsoft sql server delete command?
What is a view in sql?
How to get the query of a table in sql server?