Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Indexing on names

Indexing on names

From: I.S. Manager <ismgr_at_pctc.com>
Date: Tue, 27 Jun 2000 09:51:27 -0700
Message-Id: <10541.110557@fatcity.com>


This seems like it should be a silly question, but you never know. And I'd rather find out now.

Given a table that needs to be indexed on a field that is text (names, for instance). Can I allow mixed upper/lower case to be stored in the field, and index the table using a function that converts the field to all upper case? (using 8i). Or is there some non-intuitive gotcha that will either prevent this or cause a full-table scan in all cases?

---

Dennis Taylor
---

The opinions expressed herein are mine. Get your own opinions! Received on Tue Jun 27 2000 - 11:51:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US