> On Nov 29, 2006, at 7:16 PM, John Bachir wrote: > > [1] A typical request will be "select id from articles where > KEYWORDS % body". Will id be indexed for fulltext searching? > clearly the fulltext index on id will never be used... id is only > in the index so that it can be returned. > > [2] I anticipate that a response might be "because id is numeric > and has a cardinality of 1/1, ferret is intelligent enough to store > this efficiently in a b-tree and not waste space or time on a > fulltext index". what about if there is a year column, against > which we will never search?
Okay, I just discovered the :index option http://ferret.davebalmain.com/api/classes/Ferret/Index/FieldInfo.html So I answered the first 2 questions :) John _______________________________________________ Ferret-talk mailing list [email protected] http://rubyforge.org/mailman/listinfo/ferret-talk
