Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

In what version of Oracle did spatial indexes become optional?

User_1871Apr 2 2023 — edited Apr 4 2023

In what version of Oracle did spatial indexes become optional?

I can see that spatial indexes are optional in 18c.

Oracle 18c - Spatial Index No Longer Required

Creating and using a spatial index is no longer required for the use of any Oracle Spatial and Graph features. However, spatial indexes are highly recommended, and not using them can negatively affect performance in some cases.

However, you can require that a spatial index be used by specifying event 54700, as explained in Using Event 54700 to Require a Spatial Index for Spatial Queries.

But I'm wondering if it might have started in an earlier version.

This post has been answered by Paulzip on Apr 2 2023
Jump to Answer
Comments
Post Details
Added on Apr 2 2023
1 comment
102 views