Re: Indexes on XML tags?
I'm guessing that you could most likely define a view that is identical to your source table, with any values you wish to index as extra columns (using ExtractValue() to grab those values).
Performance-wise, no clue. I would think that such a setup is pretty snappy for retrieval, but inserts/updates could be potentially expensive.
Subject
Written By
Posted
Re: Indexes on XML tags?
June 02, 2006 10:57AM
December 01, 2006 04:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.