lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ryan Ackley" <>
Subject Re: name search from Oracle to Lucene
Date Tue, 13 May 2003 16:12:24 GMT
I would think that the keyword like is definitely using the index. One thing
that will slow down wildcard searches is the use of a wildcard in the
beginning of a string. like "%smith"  this is a very slow query that does
not use the index

----- Original Message ----- 
From: "david chan" <>
To: "Lucene Users List" <>
Sent: Tuesday, May 13, 2003 11:56 AM
Subject: name search from Oracle to Lucene

> 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