If you are configuring your system to perform SQL catalog searches using an Oracle database, you must perform the following:
Configure your Oracle
ConTextsettings to index the columns that the catalog search queries.Create the following properties files in your configuration directory:
/atg/commerce/catalog/ProductCatalog.properties
/atg/commerce/pricing/PriceLists.propertiesIn each of these new properties file, set the
simulateTextSearchQueriesproperty totrue.Note: When running on a production environment, setting
simulateTextSearchQueriestoTRUE, may affect performance.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')
