Home » Server Options » Spatial » searching for an element in varray
searching for an element in varray [message #75812] Thu, 14 August 2003 06:32 Go to next message
Muhammad Azam
Messages: 2
Registered: August 2003
Junior Member
i have to search for particular longitude/latitude value stored in sdo_ordinates_array (varray of numbers)
till now i am applying linear search but for the worst case (i.e if length of varray is too large) the execution time increases a lot.
also i cannot apply binary search here since elements in varray are not ordered .
my question is Is there any other seaching technique or search function available for type varray.
thanx in advance
Re: searching for an element in varray [message #75839 is a reply to message #75812] Fri, 10 September 2004 04:52 Go to previous message
Bryan Hall
Messages: 6
Registered: September 2004
Junior Member

One thought - You could use a materialized view and extract the coordinates, making sure that the MV is indexed. Then do your queries on the MV.
Previous Topic: Trigger to calculate length
Next Topic: MGE
Goto Forum:

Current Time: Thu Mar 30 07:29:59 CDT 2023