3 ms·
Mysql/Innodb: index organized table Pg: heap table depending upon workload this can be significant. http://use-the-index-luke.com/sql/clustering/index-organiz
by voganmother42 10y ago
Mysql/Innodb: index organized table
Pg: heap table
depending upon workload this can be significant.
http://use-the-index-luke.com/sql/clustering/index-organized-clustered-index http://use-the-index-luke.com/sql/clustering/index-organized...
- SigmundA 10y agoThis is a big thing I miss from SQL Server is clustered indexes. SQL server gives you the choice so you can go either way depending on situation. Was actually kinda of surprised after using SQL server for years then looking at Pg that it didn't have IOT at all. Thought everyone had that option.