Stream Operation Hints
Description
These hints specify a stream operation, which can be broadcast or redistribute.
Syntax
[no] broadcast|redistribute(table_list)
Parameter Description
- no specifies that the specified hint will not be used for a stream operation.
- table_list indicates tables to be joined for a stream operation. For details, see Parameter description.
Example
Hint the query plan in Example as follows:
explain select /*+ no redistribute(store_sales store_returns item store) leading(((store_sales store_returns item store) customer)) */ i_product_name product_name ...
In the original plan, the join result of store_sales, store_returns, item, and store is redistributed before it is joined with customer. After the hinting, the redistribution is disabled and the join order is retained. The optimized plan is as follows:
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot