search

greenlion / warp

WarpSQL Server, an open source OLAP focused distribution of the world's most popular open source database bundled with OLAP performance related plugins such as the WARP storage engine..
http://warpsql.blog
Other
42 stars 2 forks source link

Star schema optimization not ordering tables properly in beta 2 #58

Closed greenlion closed 2 years ago

greenlion commented 4 years ago

SSB is choosing to go from dimensions -> fact instead of fact->dimension Q1.1 is 20 seconds but should be <1

greenlion commented 4 years ago

of course STRAIGHT_JOIN hint fixes the problem, but that should not be necessary

greenlion commented 4 years ago

Not able to reproduce right now. Will try to create a repeatable test case.

greenlion commented 3 years ago

Not able to repeat and parallel query uses STRAIGHT_JOIN to order tables.

greenlion commented 2 years ago

Need to modify the rewriter plugin to further work around upstream optimizer issues because parallel query no longer uses the rewriter so the STRAIGHT_JOIN fix is lost for now.

greenlion commented 2 years ago

The current fix is to use warp_adjust_table_stats_for_joins which defaults to true