Query plan or explain plan in Warehouse
We need the ability to see the query plan. A visual query plan like you can get in Synapse or an EXPLAIN plan like in Synapse would be acceptable. This can help us troubleshoot slowly performing queries. I would very much like to see estimated row counts and such to know whether the optimizer ...
STATUS
DETAILS
New
Warehouse optimizer enhancement: cascading filter criteria on between joins
The following is a reproduction of a real-world scenario. I came up with a way to make the query faster, but I wish the optimizer would do this optimization automatically.
In the reproduction query, the where clause filters Calendar.Date. Calendar.Date is also used in the join...
STATUS
DETAILS
New