I have a product table that I want to have a multi-column (oracle text CTXCAT) index on.
If a user executes a request for Apple iPod Nano. I want the database to look at the product_name which will contain iPod Nano, then the Brand which will contain Apple, then the description. Ideally, the description would be less important than the title and brand.
Second question – If I want to narrow the search by company_id, is that better to be a straight where companyID=123. Since I neeto narrow down by company_id, am I better to convert all query data into a clob format and use MDATA.
Does anyone have a suggestion or resource to point me to?