0 Replies Latest reply: Jul 22, 2012 5:52 PM by 475694 RSS

    ctx_ddl indexs - Can you add multi indexes on one table?

    475694
      Hello

      I been doing a little testing with indexing the contents of URLs (database v11.2.x.x).

      ctx_ddl.drop_preference('TEST_URL');
      ctx_ddl.create_preference('TEST_URL','URL_DATASTORE');
      ctx_ddl.set_attribute('TEST_URL','Timeout','3600');

      create index datastores_text on test_url_search ( doc ) indextype is ctxsys.context parameters ( 'Datastore TEST_URL' );

      SELECT SCORE(1),DOC from TEST_URL_SEARCH WHERE CONTAINS(DOC, 'London', 1) > 0

      This works. i like to more

      e.g. multi words search e.g. ' London Games' where if London or games are present it return a URL with a score,

      or

      Search in the Chinese.

      The only way I can see to do this is create different indexes as the attributes for 'URL_DATASTORE' are limited. If I can what does the 'Contains' statement look like?

      Hope someone can point me in the right direction?

      Regards, Pete

      Edited by: Pete88 on Jul 22, 2012 11:52 PM