达梦对空间数据计算有优化方法吗，执行一个sql很久没结果直到OOM

为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:
【操作系统】：
【CPU】:
【问题描述】*：

更新不出结果,过段时间oom，pg只需要8s

UPDATE "NS_GRID_MANAGE"."APP_BUILDING" T1,"NS_GRID_MANAGE"."GRID_SPLIT" T2
SET T1.HOT_ID=T2.ID,T1.HOT_X=T2.X,T1.HOT_Y=T2.Y
WHERE DMGEO.ST_INTERSECTS( DMGEO.ST_POINTFROMTEXT (CONCAT( 'POINT(', T1.LNG , ' ', T1.LAT, ')') , 0),DMGEO.ST_GEOMFROMTEXT(T2.WKT,0));

select也一样效果

select T1.HOT_ID,T1.HOT_X from "NS_GRID_MANAGE"."APP_BUILDING" T1,"NS_GRID_MANAGE"."GRID_SPLIT" T2
where DMGEO.ST_INTERSECTS( DMGEO.ST_POINTFROMTEXT (CONCAT( 'POINT(', T1.LNG , ' ', T1.LAT, ')') , 0),DMGEO.ST_GEOMFROMTEXT(T2.WKT,0));
APP_BUILDING.dmp GRID_SPLIT.dmp

您看下这样符合要求不

SP_INIT_GEO_SYS(1);

/*APP_BUILDING*/
ALTER TABLE "NS_GRID_MANAGE"."APP_BUILDING" ADD "LOCATION" "SYSGEO"."ST_GEOMETRY";

UPDATE  "NS_GRID_MANAGE"."APP_BUILDING"
   SET  "LOCATION" = DMGEO.ST_POINTFROMTEXT(CONCAT('POINT(', "LNG", ' ', "LAT", ')'), 0); 
   
 COMMIT;
--ALTER TABLE "NS_GRID_MANAGE"."APP_BUILDING" DROP COLUMN "LNG";
--ALTER TABLE "NS_GRID_MANAGE"."APP_BUILDING" DROP COLUMN "LAT";

/*GRID_SPLIT*/
ALTER TABLE "NS_GRID_MANAGE"."GRID_SPLIT" ADD COLUMN GEOM ST_GEOMETRY;

UPDATE "NS_GRID_MANAGE"."GRID_SPLIT" SET GEOM = DMGEO.ST_GEOMFROMTEXT(WKT, 0);

COMMIT;
--ALTER TABLE "NS_GRID_MANAGE"."GRID_SPLIT" DROP COLUMN WKT;


CREATE OR REPLACE SPATIAL  INDEX "APP_BUILDING_LOCATION" ON "NS_GRID_MANAGE"."APP_BUILDING"("LOCATION" ASC) STORAGE(ON "TBS_DMDBA", CLUSTERBTR) ;
CREATE OR REPLACE SPATIAL  INDEX "GRID_SPLIT_GEOM" ON "NS_GRID_MANAGE"."GRID_SPLIT"("GEOM" ASC) STORAGE(ON "TBS_DMDBA", CLUSTERBTR) ;


SELECT T1.HOT_ID, T1.HOT_X
FROM "NS_GRID_MANAGE"."APP_BUILDING" T1, "NS_GRID_MANAGE"."GRID_SPLIT" T2
WHERE DMGEO.ST_INTERSECTS(
    DMGEO.ST_POINTFROMTEXT(CONCAT('POINT(', DMGEO.ST_X(T1.LOCATION), ' ', DMGEO.ST_Y(T1.LOCATION), ')'), 0),
    T2.GEOM
);