RE: Aarrrggghhh!!! Creating an index shouldn't be so hard!

Thanks for the pointer. However, in typical manual-speak, that's clear as mud. What does "derive values of SQL expressions" mean in this context, and what's the difference index-usage-wise between deriving a value and obtaining a value? Does that mean it just fails to perform the 'UPPER' ?

At 07:48 PM 10/4/00 -0400, you wrote:
>>From the SQL manual, the page on ALTER SESSION:
>
>"QUERY_REWRITE_ENABLED = { TRUE | FALSE }
>...
> This parameter has the following additional effect on the use of
>function-based indexes:
>
>If this parameter is set to TRUE, Oracle will use function-based indexes to
>derive values of SQL expressions. If in addition the QUERY_REWRITE_INTEGRITY
>parameter is set to any value other than ENFORCED, Oracle will derive such
>values even if the index is based on a user-defined (rather than SQL)
>function.
>
> If this parameter is set to FALSE, Oracle will not use function-based
>indexes to derive values of SQL expressions, but it will use such indexes to
>obtain values of real columns in the index. "
>
>And it just requires compatibility of 8.1.0 or higher.
>
>HTH,
>Diana
>
>-----Original Message-----
>From: Dennis Taylor
>To: Multiple recipients of list ORACLE-L
>Sent: 10/4/00 7:55 PM
>Subject: RE: Aarrrggghhh!!! Creating an index shouldn't be so hard!
>
>At 03:06 PM 10/4/00 -0800, you wrote:
>>>>>
>
>>Do you have the following init.ora parameters defined? They are
>>required for function-based indices: query_rewrite_integrity =
>>TRUSTED
>>query_rewrite_enabled = TRUE
>>
>> You may also need a particular compatible setting, probably at
>>least 8.1.6
>>
><<<<
>
>Well, I did have a bad compatible setting (8.1.0), but changing it to
>8.1.5 didn't help. And I'm positive that function-based indexes were
>supported in 8.1.5
>
>As to the two parameters, I can't find any indication that they tie into
>function-based indexes. Actually, after reading up on them, I'm no
>wiser.
>
>
>
>---
>Dennis Taylor
>---
>Don't worry about people stealing your ideas. If your ideas
>are any good, you'll have to ram them down people's throats. -- Please
>see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis
>Taylor INET: ismgr_at_pctc.com
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San
>Diego, California -- Public Internet access / Mailing Lists
>-------------------------------------------------------------------- To
>REMOVE yourself from this mailing list, send an E-Mail message to:
>ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
>message BODY, include a line containing: UNSUB ORACLE-L (or the name of
>mailing list you want to be removed from). You may also send the HELP
>command for other information (like subscribing).
>

---
Dennis Taylor
---
Don't worry about people stealing your ideas.  If your ideas