A.Limit the number of joined columns.

B.Implement pruning rules.

C.Use an inner join.

D.Specify the join cardinality.

A.Inner join

B.Temporal join

C.Spatial join

D.Text join

A.To check which database engines will be invoked by each node

B.To highlight potential performance issues at design-time

C.To measure the overall run-time of the query

D.To observe the generated SQL for each node

A.Use dynamic SQL.

B.Break large statements into smaller steps.

C.Use imperative logic.

D.Use SELECT *.

A.Create a .hdbprocedure file.

B.Use the Import menu in the SAP Web IDE for SAP HANA.

C.Create a .procedure file.

D.Use the CREATE PROCEDURE statement in the SQL console.