>All that said, our customers demand that we use MSSQL. The issue there is the way PK's are used -- they have to be generated as non-clustered or else PK index scans will eat up CPU, which then clogs execution memory space, etc. My takeaway is that whatever backend we use demands accommodation of some sort.
>
>
>Hank you may not realize that Postgres uses non-clustered primary keys. I mean that every index is non-clustered - I don't believe there is a clustered index in postgres. Just saying!
>
>Johnf
Hi John,
thanks. I mis-remembered the list of db's that don't from here:
http://use-the-index-luke.com/blog/2014-01/unreasonable-defaults-primary-key-clustering-keyHank