Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> context intermedia newbie question

context intermedia newbie question

From: Ed Wong <ewong_at_mail.com>
Date: 23 Oct 2002 12:27:29 -0700
Message-ID: <a5ae1554.0210231127.2c050b8a@posting.google.com>


I am newbie to context intermedia and am looking into implement it for two search purpose we need on our database. First purpose is the ablity to search on a large CLOB(30GB) column. Second purpose is create an index on varchar2 so that we can use an index for wildcard search '%text%' on varchar2.

My questions are:
1. If I implement an conext index on a 30GB CLOB column. Will the index take as much space?
2. What about performace on search such a big CLOB using context intermedia? Does it return result immediately for simple search such as "CONTAINS(Resume,'engineering')>0;"
3. Can I use context to create an index on varchar2 so that an index will be use for wildcard search '%text%'?

Thanks,

ewong
Oracle 8.1.7EE Sun Solaris 2.7 Received on Wed Oct 23 2002 - 14:27:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US