Re: Forms performance [need help!]

Forms will *Not* disable index usage because of the Case-Insensitive Query property being set TRUE for a database item. Say you typed in the three letters 'AbC' into such a field during enter-query mode, then the clause we'll generate (for that specific column) is:

   ... AND ( (COL LIKE 'Ab%' OR
              COL LIKE 'aB%' OR
              COL LIKE 'ab%' OR
              COL LIKE 'AB%') AND UPPER(COL) = 'ABC') ...

This will use an index on the COL column if another better index is not found by the optimizer.

--

Steve Muench         Email: smuench_at_oracle.com
Forms Development      CIS: 73404,676
Product Manager
Oracle Corporation