Chapter 36

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.