Categories
General

Celko on SQL: Auxiliary Tables vs. Declarative Coding

IntelligentEnterprise : Celko on SQL: Auxiliary Tables vs. Declarative Coding (printable version)

Auxiliary tables are not only portable across SQL environments and adaptable to external software, they’re often a faster, better choice than SQL with computations. And as chips and hardware get faster and cheaper, the auxiliary table approach will make even more sense.