Thanks for the question, Kiran Kumar.
Asked: October 05, 2016 - 7:23 am UTC
Last updated: October 06, 2016 - 2:53 am UTC
Version: 11.2.0.3
Viewed 1000+ times
You Asked
Hi,
I went through the articles on XMLIndex, which will be created on the table - with XMLType columns.
If i am processing PL/SQL package - procedure or functions - with XMLType variables passed through different procedures, can i make use of XMLIndex on XMLType variables within PL/SQL block - which is not having any reference to database tables. How can i create an index (or) get benefit with XMLIndex. Kindly let me know the options. Thanks.
Regards,
Kiran Nakhate
and Connor said...
Yes, an xmlindex is a physical structure on a physical segment.
It strikes me as unusual that you would need that for an xml document is coming through as a variable. If it is small, it should be quick to extract elements. If it is large, then presumably it came from a physical segment *somewhere*, which seems to be the appropriate place to have it indexed ?
Is this answer out of date? If it is, please let us know via a Comment