3728542 - SAP IQ - long running "delete" statement caused high temp dbspace usage

• A DELETE query executed in the Sybase IQ database runs for an extended duration and consumes a very high amount of TEMP DBSPACE.
• TEMP DBSPACE utilization increases significantly, impacting other queries and scheduled reporting jobs.
• The DELETE query involves two tables, with the following query structure:

```

DELETE FROM "owner"."tab_A" AS A

FROM "owner"."tab_B" AS B

WHERE A.COL1= B.COL1

AND A.COL2 = B.COL2;

```

SAP IQ 16.1

sybase iq, delete query, temp dbspace, long-running query, query optimization, many-to-many join, cartesian product, database performance, query plan, indexing , KBA , BC-SYB-IQ , Sybase IQ , How To