Query Using SDO_NN Returns Me Only Datasets With More 50km Distance
(Doc ID 2874041.1)
Last updated on SEPTEMBER 13, 2022
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
A query using SDO_NN returns only datasets with more 50km distance
The following query shows the distance for 6 registers from longitude = -89.54281 and latitude = 44.45067
The function sdo_within_distance can be used instead, however the query performance is much better with sdo_nn.
Using another point as the source returned expected results
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document