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

Last updated on APRIL 17, 2023

Applies to:

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

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