Database Tuning (MOSC)

MOSC Banner

query with view / problem with FULL ACCESS

edited Aug 3, 2011 8:26PM in Database Tuning (MOSC) 12 commentsAnswered
Hi all,
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center