This discussion is archived
1 Reply Latest reply: Sep 20, 2013 9:17 AM by kevinUCB RSS

Best Practices for Handling queries for searching XML content

Kevin_K Newbie
Currently Being Moderated

Experts: We have a requirement to get the count of 4 M rows from a specific XML tag with value begins with, I have a text index created but the query is extremely slow when I use the contains operator.

 

select count(1) from employee

where

contains ( doc, 'scott% INPATH ( /root/element1/element2/element3/element4/element5)') >0

 

what is oracle's best practices recommendation to query / index such searches?

 

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points