query-optimization

294 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Why plainning time is doubled when I call IMMUTABLE function with exatly same arguments second time?
user_46320190
•
2
1
36
query-planner query-optimization postgresql
Can a LEFT JOIN be deferred to only apply to matching rows?
user_17311440
•
5
2
220
left-join query-optimization postgresql
Azure Synapse Analytics: Can I use non-unique column as hash column in hash distributed tables?
user_127320760
•
1
1
809
azure-synapse indexing query-optimization tsql sql-server
How can I improve the select speed of my postgres query?
user_31052290
•
2
1
60
indexing query-optimization postgresql
Oracle 12.2: Optimizer changes the explain plan of a SELECT query when adding an FOR UPDATE OF ... block at the end
user_107081830
•
1
1
95
query-optimization oracle
How to optimize an Oracle UNION ALL of two 3-sec queries that takes over 200 secs ... even with rownum
user_55726740
•
2
1
795
rownum union query-optimization oracle
Why would a 'fetch' (as in duration/fetch) in MySQL Workbench take a long time for a very limited amount of data?
user_155405960
•
2
2
561
mysql-workbench query-optimization mysql
Oracle / SQL Tuning Advisor
user_27611450
•
2
1
220
database-performance query-optimization oracle
Index skip scan emulation to retrieve distinct product IDs and min/max for additional columns
user_47049760
•
3
1
1006
postgresql-performance database-performance query-optimization postgresql sql
SELECT DISTINCT is slower than expected on my table in PostgreSQL
user_47049760
•
7
1
2445
postgresql-performance database-performance query-optimization postgresql sql
Hot Questions