Configuring Oracle for Catalog Searching

If you are configuring your system to perform catalog searches using an Oracle database, you must perform the following:

  1. Configure your Oracle ConText settings to index the columns that the catalog search queries.

  2. You can also set the simulateTextSearchQueries of your Product Catalog to TRUE.

    Note: When running on a production environment, do not set the simulateTextSearchQueries to TRUE, as it will affect performance.

  3. Add a new index:

    create index
    dcs_prd_chldsku_sid_idx on dcs_prd_chldsku (sku_id) indextype is
    ctxsys.context;

    This is needed because the following SQL is generated when searching by SKU:

    SELECT DISTINCT t1.product_id,t1.product_type
    FROM dcs_product t1, dcs_prd_chldsku t2, dcs_prd_catalogs t3
      WHERE t2.product_id=t1.product_id
        AND t3.product_id=t1.product_id
        AND (CONTAINS(t2.sku_id,'xsku1126',0) > 1
        AND t3.catalog_id = 'masterCatalog')