query-optimization

294 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
What is the most efficient Data type to store categorical string variable in MySQL
user_122070100
•
1
1
81
database-performance query-optimization mysql
MySQL is not using composite index with ORDER BY clause
user_21689410
•
1
2
104
database-performance database-indexes sql-order-by query-optimization mysql
Why does removing the BINARY function call from my SQL query change the query plan so dramatically?
user_65937890
•
4
1
119
query-planner collation query-optimization mysql sql
Does having tables and materialized views in differnt schemas in Redshift have any performance impact?
user_671530
•
1
0
46
amazon-redshift data-warehouse amazon-web-services query-optimization sql
Postgres slow Trigger performance on DELETE
user_164061930
•
3
1
262
query-optimization postgresql sql performance
Oracle 19c performance issue - long operation
user_34103930
•
2
1
126
indexing query-optimization oracle performance
Order by select count(*) and LIMIT is very slow
user_96027550
•
1
1
177
laravel query-optimization mysql sql performance
Should rely on explain command when analyzing query efficiency?
user_150808250
•
1
1
30
mariadb query-optimization mysql
What is the most efficient way to know if a MySQL longblob is empty?
user_39272880
•
2
3
147
blob query-optimization mysql
SQL - Avoid full scans when joining archive tables
user_37079390
•
3
3
83
query-optimization tsql sql-server sql
Hot Questions