Re: index unused

From: Kai Zimmer <kai_at_zimmer.net>
Date: 11 Jan 2004 10:40:00 -0800
Message-ID: <d7118738.0401111040.447bbf31@posting.google.com>

Hi Ana,

thanks for your fast answer. But i still have questions...

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<6mdMb.68495$BQ5.13185_at_fed1read03>...

> p.xmldoc.extract('/TEI.2/teiHeader/fileDesc/titleStmt/title/text()').getStringVal()
> like 'Lexiko%';
>
> requires a FTS

but why exactly?
e.g. the same query without the "where-clause" still uses no index but instead the FTS:

select p.xmldoc.extract('/TEI.2/teiHeader/fileDesc/titleStmt/title/text()').getStringVal() from xmldemotable p;

so, how does indexing xml-files work then?

> P.S.
> Stop cross-posting

sorry for that, and also for the dupes :-} thanks,
Kai Received on Sun Jan 11 2004 - 12:40:00 CST