Procedural Semi-Procedural and Declarative Programming in SQL
Abstract
A lot of the time, the key to make SQL databases perform well is to take a break from the keyboard and rethink the way of approaching the problem; and rethink in terms of a set-based declarative approach.
Keywords
Procedural programming
Declarative programming
Tibbles
Tables
Files
Rows
Records
Columns
Fields
A lot of the time, the key to make SQL databases perform well is to take a break from the keyboard and rethink the way of approaching the problem, and rethink in terms of a set-based declarative approach. Joe takes a simple discussion about a problem with a User-Defined Function (UDF) to illustrate the point that ingrained procedural reflexes can often ...
Get Joe Celko's SQL for Smarties, 5th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
