[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16915532#comment-16915532 ]
Danny Chan commented on CALCITE-482: ------------------------------------ Thanks, [~hyuan] and [~Chunwei Lei] i have attached the design doc, can you help to review the design ? Maybe we should have a discussion on the doc, or under this issue, either is ok. > Implement sql and planner hints > ------------------------------- > > Key: CALCITE-482 > URL: https://issues.apache.org/jira/browse/CALCITE-482 > Project: Calcite > Issue Type: Bug > Affects Versions: 1.0.0-incubating > Reporter: Vladimir Sitnikov > Assignee: Danny Chan > Priority: Major > Labels: pull-request-available > Time Spent: 2h 40m > Remaining Estimate: 0h > > Query optimizer can never be perfect, so it makes sense to implement hints to > allow user better control the execution. > For instance: "never merge this subquery with others" (`/+ no_merge/`), > "treat those tables as leading ones" (`/*+ leading */`), etc. > Hints would enable predictable performance and the planning time would be > improved as well. -- This message was sent by Atlassian Jira (v8.3.2#803003)