Re: XML contains and extract

s.kiteley_at_abm-uk.com wrote:

> Being fairly new to Oracle and XML can anyone compare and contrast the
> following two statements with regard to performance etc .
>
> SELECT 1
> FROM xml_table
> WHERE EXTRACT(xml_text, '*/username/text()')getstringval() = 'FRED'
>
> SELECT 1
> FROM xml_table
> WHERE CONTAINS(xml_text, 'FRED within username') > 0
>
> Thanks
>
> Steve

I would expect not. The only comparison that is of value is one done with your data, on your hardware, with your operating system and version of Oracle. How hard would it be for you to do this yourself?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)