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>


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

Original text of this message