How fast is search in much row xml one value (example: id)
Hello, how fast is search in much row xml one value (value example: id or idproduct)?
I want use xml to save id and I am not sure at the speed of query like this(it's only example):
SELECT productname FROM product WHERE EXTRACTVALUE(ids,'/user/id')=5;
I cannot know speed query, when my table 'user' will be full.
I have a good reason's to save id's in xml, but how quickly can be a query in this situation?
Is it a possible?
Edited 1 time(s). Last edit at 02/08/2007 08:54AM by taurendilcz.
Subject
Written By
Posted
How fast is search in much row xml one value (example: id)
January 29, 2007 08:25AM
February 09, 2007 02:22PM
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.