Help Center > > Developer Guide> Query Performance Optimization> Tuning Queries> Hint-based Tuning> Stream Operation Hints

Stream Operation Hints

Updated at: Dec 30, 2020 GMT+08:00


These hints specify a stream operation, which can be broadcast or redistribute.


[no] broadcast|redistribute(table_list)

Parameter Description

  • no indicates that the specified hint will not be used for a join.


Hint the query plan in Examples as follows:

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:

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?

Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel