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 Index on a non-NOTNULL Column

AlanSharApr 29 2013 — edited Apr 30 2013

I am using Oracle 11g with Spatial data init.

I have a SDO_GEOM column in a table, which has NULL values for some records. I have to run spatial query based on this column so need spatial index on it. Is it possible to create Spatial Index on SDO_GEOM column even if some of these are NULL and get results by spatial query?

Thanks,
Alan

Edited by: user3883362 on Apr 29, 2013 5:59 AM

This post has been answered by NoelKhan on Apr 29 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 28 2013

Added on Apr 29 2013

#database-key-features, #error, #index, #oracle, #spatial

4 comments

526 views