Examples of simple optimizable expressions

If you have created indexes for the LastName, Age, and HireDate fields in the Employees table, the following are simple optimizable expressions:

• [LastName]="Smith"
  
  
• [Age]>=21
  
  
• #12/30/90#<[HireDate]
  
  
• Employees.[LastName]=Customers.[LastName]
  
  
• [LastName] In ("Smith", "Johnson", "Jones")
  
  
• [Age] Between 18 And 65