Michael J. Carey created ASTERIXDB-3013:
-------------------------------------------
Summary: Would be nice to eliminate unnecessary joins of related
flat views
Key: ASTERIXDB-3013
URL: https://issues.apache.org/jira/browse/ASTERIXDB-3013
Project: Apache AsterixDB
Issue Type: Improvement
Components: COMP - Compiler
Affects Versions: 0.9.7
Reporter: Michael J. Carey
Fix For: 0.9.8
Attachments: doncdata.sqlpp, doncdataviews.sqlpp.txt
The query plan for the following query against flat view has an unnecessary
join that would be good to eliminate! (This might be a good getting-acquainted
project for a person wanting to learn about the query rewriting aspect of the
SQL++ compiler.)
USE DonCData;
SELECT o.*, i.*
FROM orders_view o, items_view i
WHERE o.orderno = i.orderno;
The SQL++ materials to set up the dataverse and its datasets [^doncdata.sqlpp]
and views [^doncdataviews.sqlpp.txt]are attached.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
