What are your most common sql optimizations?

by

Reducing the amount of data that is returned, by only returning the fields required and only returning the rows required. This is the most common, as you do it for every query that returns data.

Adding indexes. This is not done as frequently, as some tables doesn’t need any other index than the one created for the primary key.

More Related Contents:

  1. SQL Server indexes – ascending or descending, what difference does it make?
  2. Fastest way to remove non-numeric characters from a VARCHAR in SQL Server
  3. MySQL not using indexes with WHERE IN clause?
  4. SQL: How to properly check if a record exists
  5. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  6. How to find rows in one table that have no corresponding row in another table
  7. How to Optimize Queries in a Database – The Basics
  8. Measuring Query Performance : “Execution Plan Query Cost” vs “Time Taken”
  9. Oracle SQL: Update a table with data from another table
  10. Oracle SQL – How to Retrieve highest 5 values of a column [duplicate]
  11. Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?
  12. How do I interpret precision and scale of a number in a database?
  13. SQL Error: ORA-00933: SQL command not properly ended
  14. A way to extract from a DateTime value data without seconds
  15. Hamming distance on binary strings in SQL
  16. How to Split String by Character into Separate Columns in SQL Server
  17. Unordered results in SQL
  18. Using PIVOT in SQL Server 2008
  19. Oracle Dynamic Pivoting
  20. Does “Right Outer Join” have any useful purpose?
  21. Produce DISTINCT values in STRING_AGG
  22. Function in SQL Server 2008 similar to GREATEST in mysql?
  23. What is it exactly a BLOB in a DBMS context
  24. Count the Null columns in a row in SQL
  25. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  26. Query times out from web app but runs fine from management studio
  27. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  28. Google Big Query SQL – Get Most Recent Column Value
  29. Copy table structure to new table in sqlite3
  30. How can I use SUM() OVER()

Leave a Comment