Lee Asher in PostgreSQL PostgreSQL Partitioning: The Most Useful Feature You May Never Have Used Partitioning in PostgreSQL was for many years a feature almost entirely ignored, and even today is often thought of only as a means to increase... 16 August 2024 10 min read
Houri Oracle Partitioned Index Efficiency PartitionedIndexEfficiency Although it is generally true that rebuilding an index represents a waste of time and resources, there nevertheless exist situations where degenerated indexes might... 09 February 2017 10 min read
Gail Shaw Gail Shaw’s SQL Server Howlers For the latest in our series of SQL Server Howlers, we asked Gail Shaw which common SQL Server mistakes and misunderstandings lead to tearful DBAs... 14 August 2012 22 min read