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)

Read next

jelena_petkovic profile image

Sve što treba da znate o `FormData` objektu u JavaScript-u

Jelena Petkovic -

digvijay-bhakuni profile image

Cracking the Proxy Puzzle: Forward vs Reverse 🧩

Digvijay Bhakuni -

adityabhuyan profile image

How Edge Computing is Revolutionizing Data Processing and IoT Applications

Aditya Pratap Bhuyan -

adityabhuyan profile image

Effective Methods for Troubleshooting Deadlocks in SQL Server

Aditya Pratap Bhuyan -