SELECT * FROM ; Everyone knows it's been not good, but now I can read the whole bunch of consequences and it's interesting so I'll share it with you guys Increased network traffic Increased CPU usage on client side Some query plan optimizations not possible Server-side memory usage Increased CPU usage on server side Hard parsing/optimization takes more time Cached cursors take more memory in shared pool - LOB Fetching #database.