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

Home -> Community -> Mailing Lists -> Oracle-L -> unnecessary DML during update of Context indexed table

unnecessary DML during update of Context indexed table

From: John Pink <jrpink_at_yahoo.com>
Date: Wed, 22 Sep 2004 15:15:50 -0700 (PDT)
Message-ID: <20040922221550.55455.qmail@web50804.mail.yahoo.com>


Hi,

I have a table with an Oracle Context (v. 9.2.0.3) index on one column. When update one of the other (non-indexed) columns in the table, Oracle still does

  1. A delete from DR$<table_name>$K
  2. An insert into CTXSYS.DR$PENDING
  3. A seemingly *bonus* insert into CTXSYS.DR$WAITING

When I have a large number of updates this is adding quite a bit of time to the process, not to mention the fact that step 'a' above causes my document to become "un-indexed" until I run a sync.

There's a good chance I am missing something here, but why should Oracle fire the procedure/triggers that update the Context version of this row when an unrelated column is updated?

Any insight is greatly appreciated.

John                 



Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 22 2004 - 17:11:23 CDT

Original text of this message

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