My Oracle Support Banner

Query Using SDO_NN Returns Me Only Datasets With More 50km Distance (Doc ID 2874041.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.