Database Software

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!

Oracle Spatial composite indexes possible?

3251458Sep 6 2016 — edited Nov 8 2016

We have a requirement for indexing an SDO_GEOMETRY object with a timestamp. Is it possible to have a composite index with both fields in the index? If so, how is it done? If it's not, will separate indexes, one spatial, one non, suffice? initial explain plan analysis did not show Oracle using the second temporal index.

Thanks for any help,

Lyle

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 6 2016

Added on Sep 6 2016

#database-key-features, #spatial

8 comments

694 views