'retry-strategy'='fixed-delay'
'fixed-delay'='10s'
'max-attempts'='3'

LOOKUP('table'='dim1', 'async'='true', 'missretry-retrypredicate'='truelookup-miss', 'retry-strategy'='fixed-delay', 'fixed-delay'='10s','max-attempts'='3')

LOOKUP('table'='dim1', 'async'='false', 'missretry-retrypredicate'='truelookup-miss', 'retry-strategy'='fixed-delay', 'fixed-delay'='10s','max-attempts'='3')

LOOKUP('table'='dim1', 'missretry-retrypredicate'='truelookup-miss', 'retry-strategy'='fixed-delay', 'fixed-delay'='10s','max-attempts'='3')

-- retry triggered by empty result, using 10s fixed-delay strategy, max attempts 3. 
SELECT /*+ LOOKUP('table'='Customers', 'missretry-retrypredicate'='truelookup-miss', 'retry-strategy'='fixed-delay', 'fixed-delay'='10s','max-attempts'='3') */ 
	o.order_id, o.total, c.country, c.zip
FROM Orders AS o
  JOIN Customers FOR SYSTEM_TIME AS OF o.proc_time AS c
    ON o.customer_id = c.id;