Re: Tuning SQL

Have you thought about using the Spatial Data option of Oracle? I haven't used it myself, but it is optimized to support this kind of query. Just trying to convince someone else to use it first and report the results.

later,
Ed Bruce
Raytheon Systems Co.

Andrew wrote:
>
> Hi Folks.
>
> I am currently doing a cross referencing bit in oracle where I
> have a postal code and obtaining the latitude and longitude from out
> Postal Code database of 750000 records. Then I am cross referencing a
> set of criteria with a list of people of 32000 records. Now if I don't
> bother with a radius calculation to narrow down the search (which
> incidenty turns up about 10000 matches) the query comes back in about 7
> seconds. However, if I include the radius calculation (ie. return the
> people that fall in a 20 km radius).. the query takes 90 seconds... This
> is too long. Oracle is running on a fairly strong Solaris box (166 Mhz
> 128 MB Ram) barely tasked at all

.
.
.
.
.
.
.