I used to have Lucene indices against tables where int id field served as a
primary key. Now I need to add full text search for tables where GUID (
SQL Server ) is a primary key.
Has anyone used guids for that purpose , any possible complications ?
My undestanding my select statement after applying Lucene search t ( if I
don't store everything there ) will be just changed
from
select ... where id in ( lucene_hit_id1 , ... , lucene_hit_id2 )
to
select ... where guid in ( lucene_hit_guid1 , ... , lucene_hit_guid2 )
