[fdo-trac] #383: SDF: Optimize "in" conditions in select filters.

[FDO]

#383: SDF: Optimize "in" conditions in select filters.
-----------------------------+----------------------------------------------
   Reporter:  brentrobinson  |       Owner:  brentrobinson                   
       Type:  enhancement    |      Status:  new                             
   Priority:  major          |   Milestone:                                  
  Component:  SDF Provider   |     Version:  3.3.1                           
   Severity:  2              |    Keywords:  SDF in filter performance select
External_id:                 |  
-----------------------------+----------------------------------------------
 The SDF Provider's FdoISelect implementation does indexed lookups, of
 values in "=" comparison conditions in the select filter, when
 appropriate. However, this type or processing is not done for "in"
 conditions. A table scan is always done when the filter contains an "in".

 The SDF Provider will be enhanced to do indexed lookups, on "in" condition
 values when all of the following are true:

     - the class being selected from has 1 identity property
     - the property for the "in" expression is the identity property for
 the class
     - types for all values match the identity property data type.
     - the filter does not contain any other expressions that cannot be
 optimized.

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/383>
FDO <http://fdo.osgeo.org/>
Feature Data Objects