Skip to Content
avatar image
Former Member

HANA VIEW properties shows execution with HINT but SQL query and SHW LOGS doesnt

Hi HANA Experts,

I have created a HANA VIEW and properties of it (EXECUTION HINTS) shows respective hint option. However, in data preview - SHOW LOGS or SQL query does not have the same (NO_HASH_JOIN). How would i get to know, property setting and SQL query are in SYNC. (Attached is a reference)

Regards

pic-1.png (63.1 kB)
pic-2.png (44.3 kB)
pic-3.png (43.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 26 at 02:49 AM

    The hints that can be entered in the view definition are not SQL hints! Please see the documentation and relevant SAP notes on details for this.

    Even if you enter a hint in the view definition, it won't show up as text in the SELECT statement as it is stored in the definition of the view.

    Add comment
    10|10000 characters needed characters exceeded