SELECT v_id, v_name, v_flag, v_date, created_by, FROM base_table WHERE (v_id, v_name,rowid) IN (SELECT v_id, v_name,max(rowid) FROM base_table WHERE a_flag = 'Y' GROUP BY v_id , v_name )The base table has around 8,000 records and this view selects about 57 records. What might be the issue with the view that is increasing temp space usage of the query?
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.