Query DB SELECT * FROM <table>

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.