What is a table called, if it does not have neither Cluster
nor Non-cluster Index?
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 automatically create a log when an exception is being received into SQL Server?
What type of Index will get created after executing the above statement?
What are parameterized reports? What are cascading parameters in ssrs reports?
Can we return Data from 4(more than 1) tables in stored procedure?
How do you open a cluster administrator?
What is a file group?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
How many ways to create table-valued functions?
what is create database syntax? : Sql server database administration
What are the different ways you can create databases in sql server?
what are the different types of replication you can set up in sql server? : Sql server database administration
What is the purpose of grouping data in a report?
Write an sql query to find first weekday of the month?
Is the order of columns in the set clause important in ms sql server?
What is the library index called?