Re: Upper/Lower Case Selektion Performance
From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 21 Feb 2006 18:20:36 -0500
Message-ID: <6d2dnYLHz8LYPWbeRVn-pg_at_comcast.com>
Date: Tue, 21 Feb 2006 18:20:36 -0500
Message-ID: <6d2dnYLHz8LYPWbeRVn-pg_at_comcast.com>
forms has a built-in 'case insenstive query' option somewhere
when this is used, it generates a where clause that will use standard indexes
another option is to create function-based-indexes (FBI) and add code to your forms to generate your own where-clause predicates formatted to use the FBI ++ mcs Received on Wed Feb 22 2006 - 00:20:36 CET