> They really should have indexing on by default for most columns, with the option of disabling unused indexes (perhaps even automatically). Oracle does that.

> They really should have indexing on by default for most columns, with the option of disabling unused indexes (perhaps even automatically). Oracle does that. I think it is not enabled by default, but once you turn it on it's pretty much automated. It creates, rebuilds, and drops indexes based on the application workload. There are third party tools for other databases (such as Dexter for PostgreSQL).