posted 17 years ago
Well, I am already doing that, but it still needs to be faster, hence the use of threads.
We are currently using:
select id,xml from xml_hash/*+Parallel,4*/
where id> startId and rownum < size
order by id;
We are using a oracle10g database.
Btw, a question. Saying parallel,4 is for the better use of multiple processors right? How do we get the database to use multiple threads, etc to process the above query faster?
The main problem here is, the xml in the above query is a Clob object and is really large!