Jul 24, 2020

Compress index and its Performance

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