Whitepaper : Relational Division
Dr. Codd’s original relational algebra had eight basic operations, seven of which are directly supported by SQL operators. However, they never added one for relational division. It can be written with the other operators, and it turns out that it is not so simple after all. This whitepaper covers different approaches to implement relational division using SQL code operators.
Topics :
Products :
Dr. Codd’s original relational algebra had eight basic operations, seven of which are directly supported by SQL operators. However, they never added one for relational division. It can be written with the other operators, and it turns out that it is not so simple after all. This whitepaper covers different approaches to implement relational division using SQL code operators.
Topics :
Products :
Joe Celko
Joe Celko is the author of a series of ten books on SQL and RDBMS (MKP/Elsevier) that have been in print for over 20 years. He served for 10 years on the ANSI/ISO database standards committee. He has written columns and articles for the IT trade press for over 30 years. He currently enjoys being a TEALS volunteer and judging the local High School Science Fest once a year.
- Granular wait state monitoring
- Continuous SQL sampling
- Intuitive drill down to view top activity
- Query plan tuning and recommendations
- Lock and latch resolutions
- Storage visibility and contention resolution