lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ben Litchfield <>
Subject Re: name search from Oracle to Lucene
Date Tue, 13 May 2003 16:08:53 GMT

Not to veer you from lucene but have you tried Oracle's function based
indexes which can use an index for like and upper.

Examples are here


On Tue, 13 May 2003, david chan wrote:

> Hi,
>  I have a table with more than 1 million records, I
> need to some search on these three fields: firstname,
> lastname, nickname
>  Now when I try to search these names from Oracle with
> some keyword "like%", or function for "upper" to
> ignore case compare, these kind of query become very
> slow even these name fields are indexed. One reason is
> because these function "like", "upper" not using the
> index.
>  I wonder it can be done better in Lucene, anyone can
> give me some idea how name search (partial name
> search, firstname search, lastname search, nickname
> search, or combination search) can be done?
>  I am thinking to dump this big oracle table to a
> plain text file, then read in and index by using
> Lucene. But now sure how to arrange these fields to
> get a good/fast result.
> Thanks.
> David
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message