> SQL Server and Oracle both default to heaps I don't think that's true for SQL ... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

hans_castorp on Jan 20, 2022 | parent | context | favorite | on: Postgres Indexes for Newbies

> SQL Server and Oracle both default to heaps

I don't think that's true for SQL Server.

If you define a primary key in SQL Server, this is automatically a clustered index.

tomnipotent on Jan 20, 2022 [–]

Any table in SQL Server without a clustered index will be stored as a heap.

https://docs.microsoft.com/en-us/sql/relational-databases/in...

hans_castorp on Jan 21, 2022 | [–]

Yes, but the _default_ (and that's what I was referring to) is a clustered index.

tomnipotent on Jan 22, 2022 | | [–]

Then the definition depends on whether you consider adding a primary key as default or not. I would not consider it default, though it is customary.

Join us for AI Startup School this June 16-17 in San Francisco!
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact