MySQL Forums
Forum List  »  Connector/Node.js

Re: Indexes on XML tags?
Posted by: Ian MacLeod
Date: June 02, 2006 10:57AM

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.

Options: ReplyQuote

Written By
April 18, 2006 04:50PM
Re: Indexes on XML tags?
June 02, 2006 10:57AM
July 05, 2006 11:04AM
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.