What is a Heap? Should you use it?

Junior MS SQL

Answer

A heap is a table without clustered index. Good for bulk loads but slow for lookups. Most tables should have a clustered index.

Want to bookmark, take notes, or join discussions?

Sign in to access all features and personalize your learning experience.

Sign In Create Account

Source: SugharaIQ

Ready to level up? Start Practice