title: How do I construct my RavenDb static indexes for this document, given these requirements?
body: <p>I have close to 3 million documents that are being stored in a RavenDb embedded instance. Everyone of the fields will be subjected to some type of filter/query/sorting, but in particular I wanted to do some type of intelligent textual search of the info and info2 columns. How might I go about constructing the RavenDb Indexes? </p>
  
  <p>My first pass at the info2 column looks like this.</p>
  
  <pre><code>store.DatabaseCommands.PutIndex("ProdcustByInfo2", new IndexDefinitionBuilder&lt;Product&gt;
  {
      Map = products =&gt; from product in products
                        select new { product.INFO2 },
      Indexes = { { x =&gt; x.INFO2, FieldIndexing.Analyzed } }
  });
  </code></pre>
  
  <p>Thank you,
  Stephen</p>
  
  <pre><code>[Serializable]
  public class Product
  {
      public string AveWeight { get; set; }
  
      public string BrandName { get; set; }
  
      public string CasePack { get; set; }
  
      public string Catalog { get; set; }
  
      public decimal CatalogId { get; set; }
  
      public decimal CategoryId { get; set; }
  
      public string Info { get; set; }
  
      public bool IsOfflineSupplierItem { get; set; }
  
      public bool IsRebateItem { get; set; }
  
      public bool IsSpecialOrderItem { get; set; }
  
      public bool IsSpecialPriceItem { get; set; }
  
      public bool IsTieredPricingItem { get; set; }
  
      public string ItemNum { get; set; }
  
      public string ManufactureName { get; set; }
  
      public string ManufactureNum { get; set; }
  
      public decimal OffineSupplierId { get; set; }
  
      public string PackageRemarks { get; set; }
  
      public decimal Price { get; set; }
  
      public decimal PriceGroupId { get; set; }
  
      public decimal ProductId { get; set; }
  
      public string ProductName { get; set; }
  
      public int Quantity { get; set; }
  
      public string SupplierName { get; set; }
  
      public string UOM { get; set; }
  
      public string Upc { get; set; }
  
      public string Url { get; set; }
  
  }
  </code></pre>