Question : Which is faster? Multiple update queries in a cursor loop, or a single query? For example, in this […]
Category: Database Optimization
How to optimize for a 50million+ row table read with SELECT statement?
Question : I have a large table (32 GB) with about 52 million rows. The table structure involves a few […]
sql-server optimize query with lots of null checks
Question : I have a query such as: select something from somewhere join stuff on condition join more_stuff on condition […]
How to optimize SQL with WHERE and ORDER BY
Question : I have the SQL statement: SELECT erp_orders_id FROM erp_orders o WHERE o.orders_export_time >= ‘2015-09-20’ ORDER BY o.erp_orders_id ASC […]
PostgreSQL and query planner
Question : I have question about query planner in PostgreSQL. I know, that this planner is taking data from pg_statistics, […]
Most efficient way to call same Table-Valued Function on multiple columns in a Query
Question : I am trying to tune a query where the same table-valued function (TVF) is called on 20 columns. […]
Optimising a query of an SSRS dataset [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Why would there be varying response times for the same query?
Question : Is there a reason why the same query executed a number of times have huge variance in response […]
Query optimization
Question : In another question they told me that the speed of a DBMS largely depends on the optimizations of […]
Postgres: my “data/backup” directory is way too large
Question : In my postgres 9.3 data directory, there exists a subdir called “backup” that is 6.1G compared to my […]