Thanks Jason. I guess I should've been a little more general about
our problem. The query that I posted was really just a reference
item to one of many queries related to /InsurancePolicy that we are
trying to optimize. Here's a more basic XQuery where our db settings
and/or query optimization could use some work:
for $policy in /InsurancePolicy
return <policy> {$policy/@*} </policy>
Basically I think what we need to do is find a way of indexing the
root node "InsurancePolicy." It seems as though the element indexing
capabilities would tackle this issue, but scalar type doesn't seem to
support a node type. I might be coming at this the wrong way, but
any suggestions would be greatly appreciated.
Patrick Force
[EMAIL PROTECTED]
_______________________________________________
General mailing list
[email protected]
http://xqzone.com/mailman/listinfo/general
