This is a good starting point for researching a topic on my blog. It’s simply a list of the various catalog(ue)s of articles that I’ve written over the years. There’s still a lot of work to do, though, as there are more than 1,500 published articles on the blog and though I have published a few of the catalogues already they are almost guaranteed to be incomplete.
The target state is for each catalogue to list all relevant articles (which means some articles will appear in more than one catalogue), generally in reverse order of publication, with the date of each entry.
Each entry lists the number of articles currently in the catalogue, breaking them down by author (viz: me / others). In the near future, when most of the catalogues have a reasonable number of recent entries, this catalogue will datestamp each listed catalogue with its last update date and highlight a short selection of the most recently updated.
- 255 columns catalogue (Blog notes 8, Other authors 2)
- ANSI catalogue (Blog notes 3)
- AWR / Statspack catalogue (Blog notes 37, Other authors 5)
- Block size catalogue
- Bug catalogue (Blog notes 18) Last update December 2022
- Compression catalogue (Blog notes 12)
- CTE / “with subquery” / Subquery factoring catalogue (Blog notes 18)
- Design catalogue (Blog notes 6) Last update July 2022
- Distributed query catalogue (Blog notes 5)
- Direct attach to the SGA (Blog notes 4) Last update April 2022
- Exadata catalogue (Blog notes 7)
- Execution Plans catalogue (Blog notes 29) Last update January 2023
- Fragmentation / rebuild / space catalogue (Blog notes 7)
- Hint catalogue (Blog notes 14) Last update July 2022
- Ignoring hints (sub-)catalogue (Blog notes 13) Last update January 2023
- opt_estimate() (sub-)catalogue (Blog notes 7, Other Authors 1)
- Indexing catalogue (Blog notes 36) Last Update March 2023
- Index Organized Tables (IOT) catalogue (Blog notes 14, Other authors 15)
- Infrastructure (geek stuff) catalogue (Blog notes 46) Last update February 2023
- Edition Based Redefinition (Other authors 1)
- Locking catalogue (Blog notes 19) Last update July 2022
- LOB catalogue (Blog notes 19) Last update August 2022
- Materialized View catalogue (Blog notes 11)
- Optimizer catalogue (Blog notes 23, external links 1, Other Authors 1) Last update November 2022
- Parallel Execution / PX / PQ catalogue (Blog notes 9) Last update November 2022
- Partitioning catalogue (Blog notes 10) Last updated February 2023
- Partition Stats (sub-catalogue) (Other Authors 22)
- Performance catalogue (Blog notes 10, Other Authors 1) Last updated October 2022
- Quiz catalogue (Blog notes 13) Last updated January 2023
- Scripts catalogue (Blog notes 32)
- Sequence catalogue (Blog notes 9)
- Statistics catalogue (Blog notes 16, Other Authors 1) Last update November 2022
- Column Group (sub-)catalogue (Blog notes 21, Other Authors 5) Last update November 2022
- Histogram (sub-)catalogue (Blog notes 25, Other Authors 2) Last update November 2022
- Partition Stats (sub-catalogue) (Other Authors 22)
- Statspack / AWR catalogue (Blog notes 37, Other Authors 5)
- Transformations catalogue (Blog notes 5, external links 4, Other authors 1) Last Update Jan 2023
- Troubleshooting catalogue (Blog notes 38) Last update January 2023
- Upgrades catalogue (Blog notes 23) Last update January 2023
Comments and related questions are welcome.