DEV Community

anhphan
anhphan

Posted on

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.

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more