Documents Created in last 5 min

Optimized version of the query is :
 

SELECT
  T0."DocDate" AS "Doc. Date",
  T1."Remarks"
FROM OWDD T0
INNER JOIN WDD1 T1 ON T1."WddCode" = T0."WddCode"
WHERE T1."Status" = 'W'
  AND T0."DocDate" >= SYSDATE - INTERVAL '5' MINUTE

Why this is more efficient:

1. SYSDATE is a direct function that can return the current date and time, and in some cases, it may perform better because it is optimized internally in HANA.
2. The query reduces the time spent on any unnecessary data processing by filtering directly on the DocDate within the last 5 minutes, ensuring only relevant rows are processed.

To retrieve documents that were created in the last 5 minutes from the current date and time in SAP HANA, you need to filter the DocDate based on the current system time. In HANA, you can use CURRENT_TIMESTAMP to get the current system time.

SELECT
  T0."DocDate" AS "Doc. Date",
  T1."Remarks"
FROM OWDD T0
INNER JOIN WDD1 T1 ON T1."WddCode" = T0."WddCode"
WHERE T1."Status" = 'W'
AND T0."DocDate" >= CURRENT_TIMESTAMP - INTERVAL '5' MINUTE

Hi Ramco,

Add this to the where condition,

T0."DocDate" >= ADD_SECONDS(CURRENT_TIMESTAMP, -300);