Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

[RESOLVED] Indexing a BLOB with Oracle Text

seb93Mar 21 2017 — edited Mar 30 2017

Hello,

I am a beginner in Oracle Text.

I created a table (docs) with two colums (numero NUMBER, doc BLOB) to store documents PDF and Microsoft Word.

I would create an index with the column doc but it doesn't work.

CODE:

create index myindex on docs(doc)

  indextype is ctxsys.context

  PARAMETERS (FILTER CTXSYS.AUTO_FILTER);

Index is really created but no words are stored in the tables (DR$MYINDEX$I, DR$MYINDEX$K, DR$MYINDEX$N, DR$MYINDEX$R) wich are created by Oracle Text.

Can you help me please ?
This post has been answered by Roger Ford-Oracle on Mar 30 2017
Jump to Answer

Comments

843811
Such optimization are done by JIT compiler (not by javac).
C++ have just the same problems, exceptions make CFG analisis more difficult but not impossible.
PS You can read JLS about volatile variables there some additional restrictions on them.
843811
zhmur is right, this makes optimization harder not impossible.

There are sicentific papers aimed at making more analysis/optimization in the presence of many try/catch blocks. For instance, JIT can reorder statements, and then put compensation code into the catch body, recovering program state back if an exception was thrown.

General principle is simple: exceptions are rare. So JIT optimizes the "normal" control flow by the cost of more complex catch body.

You may also look/post to the comp.compilers newsgroup regarding compilers and optimization techniques

Denis

-----------------------------
www.excelsior-usa.com/jet.html
High-Performance JVM for J2SE
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 27 2017
Added on Mar 21 2017
#blob, #database-key-features, #text
12 comments
4,065 views