Design catalogue

This is a list of all articles I’ve written that make some comments about things that might be worth remembering when you’re thinking about adding some new functionality to a system. Each entry has a date stamp and a short note of the contents. The articles will generally be listed most-recent first.

I am currently working backwards through my entire blog adding articles to catalogues as I go, so any individual catalogue may grow very slowly.

• GTT LOBs (Aug 2021): A note including a reminder that you can associate global temporary tables with a specific temporary tablespace.
• Sequence accelerator (Aug 2021): it’s important to think about the sequence cache size for most versions of Oracle, but an enhancement in 21c allows you to forget about it (almost). Links to a generic 4-part series on sequences written for Simpletalk.
• SQL Table Macros (Aug 2021): a possible alternative to using CTEs (or pipelined functions)
• Generating CSV from SQL*Plus (April 2021): a couple of hints and warnings.
• Finding nearest – a case study (April 2021): lateral views, subqueries and bugs
• Engineering indexes (Jan 2020): A case study about designing indexes to get maximum benefit for minimum cost.