Optimizations at a Glance

---

To help you understand the overall differences between this release and the preceding release, this section summarizes the optimizations that have been added in this release.

Table 4-1 shows a summary comparison of optimization behaviors in Pervasive.SQL 2000i and Pervasive.SQL V8.

 
Table 4-1 Optimization Behaviors by Product Version 

	Supported by Version
Type of Optimization	2000i	8.x
Restriction Optimizations
Single Predicate Optimization	ü	ü
Closed Range Optimization	ü	ü
Modified Disjunct Optimization		ü
Conjunct Optimization	ü	ü
Disjunctive Normal Form Optimization	ü	ü
Modified Conjunctive Normal Form Optimization		ü
Closing Open Ended Ranges through Modified CNF Optimization		ü
Single Join Condition Optimization	ü	ü
Conjunct with Join Conditions Optimization	Partial	ü
Modified Conjunctive Normal Form with Join Conditions Optimization		ü
Closing Join Condition Open Ended Ranges through Modified CNF Optimization		ü
Multi-Index Modified Disjunct Optimization		ü
Push-Down Filters		ü
Efficient Use of Indexes
DISTINCT in Aggregate Functions		ü
DISTINCT Preceding Selection-list		ü
Relaxed Index Segment Order Sensitivity	Partial	ü
Relaxed Segment Ascending Attribute Sensitivity	Partial	ü
Temporary Table Performance		ü
Row Pre-fetch		ü