Selecting from view (by another scheme) doesn't use spatial index
679545Jan 13 2009 — edited Jan 19 2009
I'm using XE to store spatial data. Data are in my general_scheme. I created restricted_scheme+ just with basic privileges to access the data.
The problem starts when I'm selecting data by restricted_schema+ from general_scheme.view+ - I notised that select operation don't use spatial index of the table and select is too slow (f.g. 30 sec. per one select). When I'm selecting data by restricted_scheme+ from data_scheme.table+, everything goes well.
Is that a bug?
It relates just to spatial index.
I tested these events on Oracle 11g and there was no problem with selecting by restricted_scheme.
Thanks for advices.