Web Article - 10 common mistakes Java developers make when writing SQL

1. Forgetting about NULL
2. Processing data in Java memory
3. Using UNION instead of UNION ALL
4. Using JDBC Paging to page large results
5. Joining data in Java memory
6. Using DISTINCT or UNION to remove duplicates from an accidental cartesian product
7. Not using the MERGE statement
8. Using aggregate functions instead of window functions
9. Using in-memory sorting for sort indirections
10. Inserting lots of records one by one

Full Article

Powered by Blogger