query with view / problem with FULL ACCESS
I have view V_GPS. The query is complicated and contains a lot of tables.
The view works fast when SELECT use condition list of values in IN clause.
select * from V_GPS
where g3e_fid in (517302,523340,55053,10284111,567971);
-- part of explain plan when you can see that indexes are used
250 FILTER
193 NESTED LOOPS Cost: 16 Bytes: 1,495 Cardinality: 13
190 NESTED LOOPS Cost: 14 Bytes: 1,209 Cardinality: 13
187 NESTED LOOPS Cost: 12 Bytes: 793 Cardinality: 13
184 NESTED LOOPS Cost: 10 Bytes: 494 Cardinality: 13
181 INLIST ITERATOR
180 TABLE ACCESS BY INDEX ROWID TABLE GINIUS.B$B_OWN_INF_N Cost: 7 Bytes: 420 Cardinality: 20
179 INDEX RANGE SCAN INDEX GINIUS.IDX_B$B_OWN_INF_N_FID Cost: 5