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
- 9371 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 update a field in SQL after ALTERING a row?
What are the types of subscriptions in SQL Server replication?
What is difference between oltp and olap?
How do you delete duplicate records in sql server?
What is trace flag in sql server?
How to delete an existing row with delete statements in ms sql server?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What is Cross Join and in which scenario do we use Cross Join?
What is query optimization process?
When you use @@error and try-catch?
How to encrypt Strored Procedure in SQL SERVER?
Explain something about security and SQL Azure?
Which language is supported by sql server?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is the difference between dataadapter and datareader?
