![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for RAD Studio XE3 (Delphi Win64) » Advanced Topics » Filter Optimization |
Customer table Field Data Type Index --------------------------------------------------- ID Integer Primary Index Name String[30] State String[2] Secondary, case-sensitive, non-unique, ascending, index TotalOrders BCD[2]
(TotalOrders > 10000) and (State='CA')
Customer table Field Data Type Index --------------------------------------------------- ID Integer Primary Index Name String[30] State String[2] Secondary, case-insensitive, non-unique, ascending, index
(UPPER(State)='CA')
Optimized Condition = Fully-Optimized filter Un-Optimized Condition = Un-Optimized filter Optimized Condition AND Optimized Condition = Fully- Optimized filter Optimized Condition AND Un-Optimized Condition = Partially- Optimized filter Un-Optimized Condition AND Optimized Condition = Partially- Optimized filter Un-Optimized Condition AND Un-Optimized Condition = Un- Optimized filter Optimized Condition OR Optimized Condition = Fully- Optimized filter Optimized Condition OR Un-Optimized Condition = Un- Optimized filter Un-Optimized Condition OR Optimized Condition = Un- Optimized filter Un-Optimized Condition OR Un-Optimized Condition = Un- Optimized filter
Employee Field Data Type Index ---------------------------------------------------------------------- LastName String[30] Primary Index (both fields are part of the FirstName String[20] Primary Index primary index)
(LastName='Smith') and (FirstName='John')
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |