Hi,
I'm basically a java developer. Been assigned some sql performance issue.

My application queries a 'view' which (logically) contains 200,000 records.
Problem is : The query is very slow..
Here are some details about my view :
The view contains 5 nested loops, two sorts and a merge join.

Explain Plan for my query:

2.1 VIEW MY_VIEW (1,170,2039)
3.1 SORT GROUP BY (1,150,2039)
4.1 FILTER (,,)
5.1 NESTED LOOPS (1,150,2037)
6.1 NESTED LOOPS (1,134,2035)
7.1 NESTED LOOPS (1,118,2032)
8.1 NESTED LOOPS (1,107,2031)
9.1 NESTED LOOPS (1,96,2030)
10.1 MERGE JOIN (318,15582,1712)
11.1 SORT JOIN (43605,1308150,765)
12.1 INDEX FAST FULL SCAN I1_AANOTE (43605,130815 0,36)
11.2 SORT JOIN (72607,1379533,947)
12.1 INDEX FAST FULL SCAN I3_ACOUNTACS (72607,1379533,73)
10.2 TABLE ACCESS BY INDEX ROWID AACCT (29741,1397827,1)
11.1 INDEX UNIQUE SCAN PK_AACCT (29741,,)
9.2 TABLE ACCESS BY INDEX ROWID AACCTSTATCDTB (2,22,1)
10.1 INDEX UNIQUE SCAN PK_AACCTSTATCDTB (2,,)
8.2 TABLE ACCESS BY INDEX ROWID AASTATCDTB (4,44,1)
9.1 INDEX UNIQUE SCAN PK_AASTATCDTB (4,,)
7.2 TABLE ACCESS BY INDEX ROWID AAVER (41159,658544,3)
8.1 INDEX RANGE SCAN PK_AAVER (41159,,2)
6.2 TABLE ACCESS BY INDEX ROWID ACCOUNT (3977854,63645664,2)
7.1 INDEX UNIQUE SCAN PK_ACCOUNT (3977854,,1)
5.2 SORT AGGREGATE (1,20,)
6.1 FIRST ROW (1,20,2)
7.1 INDEX RANGE SCAN (MIN/MAX) I2_AANOTE (1,,2)


Please let me know if the info i gave is incomplete..