My question is this: What matters more,in large sets of data, execution time, or execution cost?
As a DB guy, I think both of them are important. As a client, its the response time. So, both of them are important.
But my point on the script by Nitin is just WHY would I ever like to alter my base table to get the concatenated values. Its not practical. Or would I create a temporary table for the data to get the things done. There are alot of issues involved. Considering 1 million rows example, its not workable.
Plz clear me if I am missing something.