Need some help with CTXXPATH index + EXISTSNODE

From: Jim <chicagozer_at_comcast.net>
Date: 5 Feb 2004 07:24:13 -0800
Message-ID: <2145092c.0402050724.37a3df18@posting.google.com>

Hi,

Oracle 9i Release 2 on Windows ....

I have created a table w/ a XMLTYPE column and created a CTXXPATH index accordingly.

My queries are of the style --

SELECT * from mytable
WHERE EXISTSNODE(xmldata, '//DocumentId[.="835"]', 'xmlns="http://myurl"') = 1

When I use a namespace in the existsnode fragment, Oracle never seems uses the index -- leaving it out eliminates the issue.

Am I precluded from indexed searches when using a namespace?

Thanks!

Jim Received on Thu Feb 05 2004 - 09:24:13 CST