5 ms·
> is the typical mechanism to sort the data on the disk in RDBMS SQL Server and Oracle both default to heaps (though it's rare to see a SQL Server table withou
by tomnipotent 5y ago
> is the typical mechanism to sort the data on the disk in RDBMS
SQL Server and Oracle both default to heaps (though it's rare to see a SQL Server table without a clustered index).
- hans_castorp 5y ago> 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 5y agoAny table in SQL Server without a clustered index will be stored as a heap. https://docs.microsoft.com/en-us/sql/relational-databases/indexes/heaps-tables-without-clustered-indexes?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/relational-databases/in...
- hans_castorp 5y agoYes, but the _default_ (and that's what I was referring to) is a clustered index.
- tomnipotent 5y agoThen 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.