Spatial processing using oracle table functions
Ravi Kanth V Kothuri, Siva Ravada, Weisheng Xu · 2005
Spatial joins and spatial index creation are two of the most expensive operations in Oracle Spatial. Since spatial indexing is implemented in extensible indexing framework where queries only return rows from a single table, spatial joins could not be effectively and efficiently implemented in Oracle8i and prior releases. On the other hand, spatial indexcreationinvolvesmuchcomputationorI/Othatcouldbe easily parallelized. In this paper, we describe how Oracle Spatial applies parallel and pipelined table function technology to perform fast spatial joins and parallel index creation. This technologyhas been introduced in Oracle9i and allows users to iteratively return subsets of result rows to be used in the “from” clause of a SQL query. We present our experiences with these implementations and examine the performance on real datasets.