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

Scan Operation Hints

Updated at: Jul 15, 2020 GMT+08:00

Function

These hints specify a scan operation, which can be tablescan, indexscan, or indexonlyscan.

Syntax

1
[no] tablescan|indexscan|indexonlyscan(table [index])

Parameter Description

  • no indicates that the specified hint will not be used for a join.
  • table specifies the table to be scanned. You can specify only one table. Use a table alias (if any) instead of a table name.
  • index indicates the index for indexscan or indexonlyscan. You can specify only one index.

indexscan and indexonlyscan hints can be used only when the specified index belongs to the table.

Scan operation hints can be used for row-store tables, column-store tables, HDFS tables, HDFS foreign tables, OBS tables, and subquery tables. HDFS tables include primary tables and delta tables. The delta tables are invisible to users. Therefore, scan operation hints are used only for primary tables.

Examples

To specify an index-based hint for a scan, create an index named i on the i_item_sk column of the item table.

1
create index i on item(i_item_sk);

Hint the query plan in Examples as follows:

1
2
explain
select /*+ indexscan(item i) */ i_product_name product_name ...

item is scanned based on an index. 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