Pervasive logo

Prev SQL Engine Reference Next

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


ü

ü

ü

ü


ü

ü

ü

ü

ü


ü


ü

ü

ü

Partial

ü


ü


ü


ü


ü




ü


ü

Partial

ü

Partial

ü


ü


ü


Prev
Performance Reference
Contents
Up
Check for Revisions
Next
Restriction Analysis