SQL Data Analyst — Hard
Key points
- SELECT * retrieves all columns, even unnecessary ones
- This increases I/O and network traffic unnecessarily
- Queries can break if the table schema changes unexpectedly
- It's best practice to specify only the needed columns in analytical queries
Ready to go further?
Related questions