user12081556 wrote:One column? Well no, that doesn't make much sense as you can simply return that one column as the object type it represents (String, Date, whatever). Or perhaps you meant one row? Of course memory has absolutely nothing to do with it, why would you even consider thinking about that in this situation? Couple of bytes of overhead where you likely have a few gigabytes of it available.
Does it make sense to return a result set of one column into an object that represents that table? It seems like a waste of memory, but maybe I am missing something.
If you're thinking object creation is overkill, what's Plan B?Use C I guess :)
user12081556 wrote:My question on this is: why do you want to get only one column from the table?
Yeah I was meaning one column (a String column)