Search results for query: *

Can you please let me know how to avoid "Collection Iterator Pickler Fetch" I had a PLSQL Function which returns more than 23 columns as Output.I am using 3 queries inside this PLSQL Function. When I am running this 3 queries separately I am getting the cost as 3,4 and 6 for the individual...

Thanks a lot sir, The Cost has been drastically reduced to 3 now. SELECT STATEMENT, GOAL = ALL_ROWS Cost=3 Cardinality=2 Bytes=78 CPU cost=83320 Optimizer=ALL_ROWS IO cost=3 INDEX FAST FULL SCAN Object owner=ERM_DEV Object name=ERM_RPR_RISK_EVT_DESC_IDX Cost=3 Cardinality=2 Bytes=78 CPU...

Thanks a lot Sir , After passing all the columns in the where clause the cost has been reduced to 8,But the problem is I dont have all the values of the column. Out of the 10 foreign keys I have values of only 3 keys and that is a composite primary key. Also does the below point means I will...

I guess yes.But not sure how to read the plan. This was the query fired : select /*+ first_rows */ a.event_desc from erm_rpr_risk_dtls_t a where a.rmu_id= 1 and a.rpr_vrsn_no= 1 and a.risk_seq_no= 1 Below is the plan SELECT STATEMENT, GOAL = HINT: FIRST_ROWS Cost=37 Cardinality=2...

I had a table with 32 columns out of which one is a composite primary key and have 10 foriegn keys. I am writing a simple query with where clause having a composite primary key. But still I am getting cost of the query as 37. Can you please suggest how can i optimize the cost of the query...

Hi All , I want to write a case statement in where clause such that if Value is TAG1 then in where clause it will search for TAG2 and TAG3. Value is TAG2 then in where clause it will search for TAG1 and TAG3. Value is TAG3 then in where clause it will search for TAG2 and TAG1. if...