New answers tagged database-recommendation
If you maximum use it for Inserting or updating purpous, then create 2 tables and make snapshort operation (Replication). If you want to Select operation then make single table and Indexed this table.
When every document is about shoes, then the term "shoe" will likely do little for the relevancy score, which may be enough of a filter in many cases. Still, as you point out, if there are no sport shoes and a document contains multiple occurrences of "shoes", that document may be considered relevant enough to be included in the result and without ...
Top 50 recent answers are included