My Oracle Support Banner

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 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

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

Cause

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
Symptoms
Cause
Solution


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