How to add metadata query hints for SAP HANA data connection in a preference

Product: TIBCO Spotfire Analyst

Versions: 10.3.4. LTS HF-028,10.10.3 LTS HF-013,11.2.0 HF-001, v11.3.0 and later

Summary:

How to add metadata query hints for SAP HANA data connection in a preference

Details:

• In some cases, we can increase metadata queries performance by providing hints to SAP HANA
• HINTS is a feature in SAP HANA, with which you can include a WITH HINT clause in queries to guide how to get metadata. 
• As the best set of hints may vary depending on customer requirements, these hints should be provided as settings initially.

Note: The hints will be used when retrieving metadata for information views, tables, views, and calculated views but not other database objects.

Resolution:

• Configure Spotfire to add HINTS to metadata queries to SAP HANA. Use this preference setting:  Connectors > SAP HANA > MetadataQueryHints

• Specify the HINTS in an array, one HINT clause per line in the dialog:

Example,
hana_hint_1
hana_hint_2

• The HINTS are included in a WITH HINT clause in the metadata queries to SAP HANA.

Example
[…] WITH HINT ( hana_hint_1, hana_hint_2 )

• For information about how to use SAP HANA HINTS, see the official documentation for SAP HANA.

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.02/en-US/4ba9edce1f2347a0b9fcda99879c17a1.html