What is Heap Table? What is the advantage and dis advantage of Heap Table?

Post

View All

Gangadhar

What is Heap Table? What is the advantage and dis advantage of Heap Table?

By Gangadhar in SQL Server on Aug 20 2009

0
11.8k
1

Post Your Answer

Aug, 2009 20
The tables without indexes are called Heap tables.

Advantage: Insert/Update/Delete/Bulk Insert performance is fast

Dis Advantage: Search performace will be slow
- 0