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
- 9552 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
What are different types of database indexes?
What is the maximum size of sql server database?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What are various limitations of the views?
In which format does an image save in SQL Server database ?
what is package and it uses and how can u call a package
What the different topologies in which replication can be configured?
What does Master database contains?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
how to control the amount of free space in your index pages? : Sql server database administration
What is field in algebra?
How to delete all rows with truncate table statement in ms sql server?
Explain filtered indexes?
Why and when do stored procedure recompile?
Explain about integration services of Microsoft SQL server?
