Example Schema

This appendix contains all the required create and insert statements to run the examples from the book. For the sake of didactics, the book’s main body does not always include all details for the examples.

Contents

1. Db2 (LUW)

   1. The where clause

   2. Testing and Scalability

   3. The Join Operation

   4. 3-Minute Test

2. MySQL

   1. The where clause

   2. The Join Operation

   3. Clustering Data

   4. Sorting and Grouping

   5. Partial Results

   6. 3-Minute Test

3. Oracle

   1. The where clause

   2. Testing and Scalability

   3. The Join Operation

   4. Clustering Data

   5. Sorting and Grouping

   6. Partial Results

   7. Insert, Delete and Update

   8. 3-Minute Test

4. PostgreSQL

   1. The where clause

   2. Testing and Scalability

   3. The Join Operation

   4. Sorting and Grouping

   5. Partial Results

   6. Insert, Delete and Update

   7. 3-Minute Test

5. SQL Server

   1. The where clause

   2. Testing and Scalability

   3. The Join Operation

   4. Clustering Data

   5. Sorting and Grouping

   6. Partial Results

   7. Insert, Delete and Update

   8. 3-Minute Test

6. SQLite

   1. The where clause

   2. The Join Operation

   3. 3-Minute Test

7. Gupta SQLBase

   1. The where clause

   2. The Join Operation