New answers tagged join
0
votes
Select tables data with sum of other tables
Think through it this way it will be executed:
JOIN the user and history tables together. Imagine the resulting "table" that contains all combinations of rows -- based on ON, which ...
3
votes
SQL Server 2014 Cardinality Estimator estimate final number of rows after OUTER JOIN is less than number of rows from initial table
Cardinality Estimation is just an estimation. Many times it won't be the exact number of rows, for a multitude of reasons. But if it is, great, that means the SQL Engine was able to do its job ...
1
vote
Accepted
Join order and nullability
Based on some experimentation and my understanding of how join order works in Postgres, I think the following rules can be applied:
Note: in the diagrams below, ! denotes not nullable, ∅ denotes ...
-1
votes
Join order and nullability
When working with the results of a database query inside a statically typed application, we need to know whether a particular column could return null or not.
No, you do not. You need to know if the ...
2
votes
ORA-12015 materialized view complex query error with simple join two table
5.2.2 About Materialized Views Containing Only Joins
If you specify REFRESH FAST, Oracle Database performs further
verification of the query definition to ensure that fast refresh can
be performed if ...
3
votes
Accepted
Worst performance multiple left join big tables after restore DB
Duplicate indexes
For starters, it certainly does not help that you duplicated most of your indexes. Your setup is struggling with insufficient cache as indicated by the large numbers of read's in the ...
Top 50 recent answers are included
Related Tags
join × 1945mysql × 736
postgresql × 370
sql-server × 366
performance × 202
query × 122
query-performance × 117
oracle × 111
subquery × 107
select × 105
group-by × 93
optimization × 83
index × 66
count × 66
t-sql × 61
update × 56
mariadb × 52
database-design × 48
union × 48
aggregate × 46
view × 40
execution-plan × 31
foreign-key × 31
sum × 28
sql-server-2008 × 25