3 ms·
True, but MSSQL style clustering has it's own performance trade-offs in terms of slower writes, fillfactor bloat etc.
by adwf 8y ago
True, but MSSQL style clustering has it's own performance trade-offs in terms of slower writes, fillfactor bloat etc.
- polskibus 8y agoIt's not going to be slower vs an unordered heap + a separate index that includes all the columns. Hence MS SQL implementation is superior. If you don't want a PK, then MS SQL offers you an undordered option.