David, thank you for your response. Yes, this is how I understand them
to work too. However, in my particular use of the table variable I
don't think there will ever be a case were SQL will be forced to write
to disk. As I have stated above I am just using this object to whole
several tokens so that I can sort them, sorta like an array sort. For
Example: exec MyFunction '|B|Z|D|A|' whould return an output of
'ABDZ'. This is all that I am doing and I need to have this done
extremely fast. In MSSQL I have to use a table variable to get the
speed I need. In Oracle it looks as if I can use the global temporary
table or I can write a java class to tokenize and sort which I suspect
would be the fastest. Anyhow, all of you have been a huge help and I
thank you very much.
TFD
Received on Tue May 24 2005 - 08:28:22 CDT
