i get 1 row as result with the column sztitular = "rodillos de medidas"
SELECT x.lid as id, x.sztitular as titular, e.szname as proName, x.szresumen as resumen, b.sztitle as catName, f.szname as secName, d.szname as cliName, x.datecreation as datecreation FROM CPR_PRACTICAL_CASE x,ctg_category b, CPR_CLIENT d, pro_product e, CAT_SECTOR f, CPR_PCASE_PRODUCT g, CPR_PCASE_SECTOR h, PRO_PRODUCTCATEGORY i WHERE x.lid = g.lpcaseid and e.lid = g.lproductid and x.lid = h.lpcaseid and f.lid = h.lsectorid and x.lclientid = d.lid and i.lproductid = e.lid and b.lid = i.lcategoryid AND x.szlocale = 'es-ES' AND x.bavailable = '1'
the query returns an empty set.. i really don't understand why because the term "rodillos" is present in the row's column called "sztitular"...
AND CONTAINS( x.sztitular, 'rodillos',1) >0
create index ITXT_TITULAR on CPR_PRACTICAL_CASE(sztitular) INDEXTYPE IS CTXSYS.CONTEXT;
Furthermore you could add a sync to the index creation, after that every commit will also sync the index:
begin ctx_ddl.sync_index('ITXT_TITULAR' ); end;
Herald ten Dam
create index ITXT_TITULAR on CPR_PRACTICAL_CASE(sztitular) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS ('SYNC ( ON COMMIT)') ;