> A non-clustered and clustered index has resovle the problem, > but Lucene can > not do the same thing like that?
Well, I bet the database solution is the best, as long as you do not search in big text fields or you need special fulltext features like fuzzy search etc. Synchronizing a lucene index with such a big database is pure overkill, as long as the database does the job. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]