select nodename, sum(length) length from coaxcable c, nodeboundary n where sdo_relate (c.ogc_geometry,n.ogc_geometry,'MASK=ANYINTERACT')='TRUE'
group by Nodename ---8 sec with parallel and cache and compress for indexes only because due to version enable table compress table will not work
select nodename, sum(length) length from coaxcable c, nodeboundary n where sdo_relate (c.ogc_geometry,n.ogc_geometry,'MASK=ANYINTERACT')='TRUE'
group by Nodename ---8 sec with parallel and cache
--COMPRESS FOR INDEX ALONE WILL NOT GIVE MORE PERFORMANCE FOR QUERY
select nodename, sum(length) length from coaxcable c, nodeboundary n where sdo_relate (c.ogc_geometry,n.ogc_geometry,'MASK=ANYINTERACT')='TRUE'
group by Nodename ---32 sec without parallel and withcache
No comments:
Post a Comment