Examples of complex optimizable expressions
These examples assume that you created indexes for the LastName and HireDate fields but not the MiddleInitial or FirstName fields. The following table lists examples of combined simple expressions and the extent to which the result is optimized.
| Optimizable expression |
Operator |
Optimizable expression |
Result |
| [LastName]="Smith" |
And |
[Hire Date]<#12/30/90# |
Rushmore-optimizable |
| [LastName]="Smith" |
Or |
[Hire Date]<#12/30/90# |
Rushmore-optimizable |
| Optimizable expression |
Operator |
Expression not optimizable |
Result |
| [LastName]="Smith" |
And |
[MiddleInitial]="C" |
Partially optimizable (but doesn't use Rushmore) |
| [LastName]="Smith" |
Or |
[MiddleInitial]="C" |
Not optimizable |
| Expression not optimizable |
Operator |
Expression not optimizable |
Result |
| [FirstName]="Terry" |
And |
[MiddleInitial]="C" |
Partially optimizable (but doesn't use Rushmore) |
| [FirstName]="Terry" |
Or |
[MiddleInitial]="C" |
Not optimizable |