If you are configuring your system to perform catalog searches using an Oracle database, you must perform the following:
Configure your Oracle
ConTextsettings to index the columns that the catalog search queries.You can also set the
simulateTextSearchQueriesof your Product Catalog toTRUE.Note: When running on a production environment, do not set the
simulateTextSearchQueriestoTRUE, as it will 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')
