Message-Id: <10541.110608@fatcity.com> From: "djordjej" Date: Tue, 27 Jun 2000 20:30:21 -0400 Subject: Re: Indexing on names On 8i it is possible, before 8i it was not, Djordje -----Original Message----- From: I.S. Manager To: Multiple recipients of list ORACLE-L Date: Tuesday, June 27, 2000 6:36 PM Subject: Indexing on names >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! >--- >-- >Author: I.S. Manager > INET: ismgr@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@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).