One index or many index


Just want to find out if there is a preferred way or not for the case below.

  • I sell products in 40 countries.
  • Each country has about 50,000 products.
  • Product fields/mapping in country X is always same.
  • Product fields/mapping in country X and Y may be little different but 90% same.

Should I create a single index to hold whole data or should I create 40 dedicated indexes per country? My search mainly be a Geo Polygon Query.


This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.