select /*+ INDEX(ODMZ_CONTEXT_ROUTER IFS_TEXT) */
 count(*)
from ODMZ_CONTEXT_ROUTER
where
  CTXSYS.CONTAINS(ODMZ_CONTEXT_ROUTER.CONTENTPROCEDURE,'search text', 1) > 0;

select /*+ INDEX(ODMZ_CONTEXT_ROUTER IFS_TEXT) USE_HASH(SC1 SC0 p a) */
 distinct SC0.id, CTXSYS.SCORE(1)/(0.3*log(10, SC1.contentsize)) score
from ODMZ_CONTEXT_ROUTER, odm_contentobject SC1, odm_document SC0
 join odm_relationship r on (SC0.id = r.rightobject)
  join
   (select fi.rightid
     from odmz_folderindex fi
     where fi.lev = 0 and fi.leftid in
      (select fi2.rightid
        from odmz_folderindex fi2
        where fi2.lev = 1 and fi2.leftid =36128
      )
    union
    select fi.rightid
     from odmz_folderindex fi
     where fi.lev = 1 and fi.leftid =36128
   ) f
  on (f.rightid = r.leftobject), odm_publicobject p, odmz_acl_discoverer a, odmz_class_hierarchy ch
 where
  CTXSYS.CONTAINS(ODMZ_CONTEXT_ROUTER.CONTENTPROCEDURE,'search text', 1) > 0 AND
  ODMZ_CONTEXT_ROUTER.id = SC1.content AND
  SC0.CONTENTOBJECT = SC1.ID AND
  SC0.id = p.id AND
  p.acl = a.aclid AND
  ((p.owner =1074 and a.userid = 0) OR ( p.owner != 1074 and a.userid = 1) OR ( p.owner != 1074 and a.userid = 1074)) AND
  p.deletor = 0 AND
  p.classid = ch.subclassid and
  ch.classid=182209
ORDER BY score DESC;