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