• A HEAP is a list of rows connected to each other through a point
  • Each row has a fixed maximum size before moving on to the next row.
  • each row has to be scanned to find what you are looking for

When to use HEAPS

  • This is the default way in which tables are created. No contraints, etc
  • Do not use HEAPS when you want to store data that is grouped together
  • Avoid on large tables
  • Good for getting data in, but is inefficient for getting data out.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top