SQL/MP Query Guide

Contents

HP NonStop SQL/MP Query Guide—524488-003

Figures (continued)

Figure 3-2. Sort Merge Join 3-27

Figure 3-3. Key-Sequenced Merge Join 3-29

Figure 3-4. Hash Function Example 3-30

Figure 4-1. Parallel Execution of a SELECT Statement 4-15

Figure 4-2. Single-Row Access 4-22

Figure 4-3. Real Sequential Block Buffering (RSBB) 4-23

Figure 4-4. Virtual Sequential Block Buffering (VSBB) 4-25

Tables

Table i. Summary of Contents xiii

Table 1-1. Date-Time Data Types 1-21

Table 1-2. Sample Table for Date-Time and INTERVAL Arithmetic Examples 1-22

Table 1-3. Date-Time Functions 1-24

Table 1-4. Evaluation of Expressions That Contain Null Values 1-40

Table 1-5. Aggregate Functions 1-41

Table 3-1. The Effect of =_SQL_CMP_EQ_LIMIT Values on Compilation

Time 3-20

Table 3-2. Rules for Expansion of Useful Equality Predicates 3-21

Table 3-3. Calculation of Resource Costs for Joins 3-36

Table 3-4. Comparison of Join Strategies 3-37

Table 4-1. A Comparison of Buffering Modes 4-27

Table 5-1. Selectivity Formulas for Multivalued Predicates 5-5

Table 5-2. Computed and Default Selectivity Values for Predicates 5-9

Table 5-3. Costs for Indexes With Predicates 5-16