What is the effect of adding INCLUDE columns to a non-clustered index in SQL Server or PostgreSQL?

Advanced SQL Developer Hard

Advanced SQL Developer — Hard

What is the effect of adding INCLUDE columns to a non-clustered index in SQL Server or PostgreSQL?

Key points

  • INCLUDE columns do not become part of the index key
  • They are not stored in a separate heap page
  • They are not compressed and stored only when values differ from key columns

Ready to go further?

Start full exam Practice more questions

Related questions