Our developers store XML docuements inside CLOBS and
want to search the CLOB contents based on a search
string. I have lot of concern about such queries but
could benefit from someone on the list who has already
solved the performnce issues with such searches.
Typical existing queries I have
Read the fine docs on Technet on Intermedia text, as well as the
XML development kit.
-Joe
On Thu, 2002-01-24 at 10:20, sundeep maini wrote:
Our developers store XML docuements inside CLOBS and
want to search the CLOB contents based on a search
string. I have lot of concern about such
Our developers store XML docuements inside CLOBS and
want to search the CLOB contents based on a search
string. I have lot of concern about such queries but
could benefit from someone on the list who has already
solved the performnce issues with such searches.
Typical existing queries I have come
Sundeep,
You couldn't have made a better case for using interMedia Text index(es) on
your CLOB column(s) if you'd had help from Oracle Marketing! ;-)
interMedia Text is very powerful and efficient. We use it to index and
search almost 15 million CLOB documents, many in HTML format.