Interested to Buy Any Domain ? << Click Here >> for more details...
What is a table called, if it does not have neither Cluster
nor Non-cluster Index?
- 2 Answers
- 9482 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Explain the difference between HTTP and HTTPS in database?
What is difference between drop truncate and delete?
How to achieve Paging of records in SQL SERVER?
What is the meaning of sql server?
Tell about MOM Tool(Microsoft Operator Manager)?
What is mapping schema?
What do you mean by stored techniques? How would we use it?
What is the difference between varchar and varchar(max) datatypes?
Can we use custom code in ssrs?
What are the types of subquery?
How do I manually uninstall an instance of sql server 2016?
How to create stored procedures with parameters in ms sql server?
How many databases can we create in a single server?
Explain boyce and codd normal form(bcnf)?
What is 1nf normalization form?
