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 O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.