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
- 9685 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
How to create a ddl trigger using "create trigger" statements?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What are parameterized reports?
What is code near application topology?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What is difference between count (*) and count column?
Explain filtered indexes?
Explain about the command-line tool SQLCMD?
Explain error handling in ssis?
What is after dml trigger?
What are the advantages of using stored procedures in sql server?
How can you ensure that the database and sql server based application perform well?
What is the difference between writing data to mirrored drives versus raid5 drives
What is the difference between push and pull subscription? : sql server replication
