jps_mega
	7/17/2008 11:50:02 AM		SELECT STATEMENT							CHOOSE		0		626	626	1						
	7/17/2008 11:50:02 AM		SORT	AGGREGATE								1	0	1		1						
	7/17/2008 11:50:02 AM		VIEW			JPS		1				2	1	1	626	13						
	7/17/2008 11:50:02 AM		WINDOW	SORT								3	2	1		13	858					
	7/17/2008 11:50:02 AM		WINDOW	SORT								4	3	1		13	858					
	7/17/2008 11:50:02 AM		WINDOW	SORT								5	4	1		13	858					
	7/17/2008 11:50:02 AM		VIEW			JPS		2				6	5	1	621	13	858					
	7/17/2008 11:50:02 AM		WINDOW	SORT								7	6	1		13	1612					
	7/17/2008 11:50:02 AM		NESTED LOOPS	OUTER								8	7	1	621	13	1612					
	7/17/2008 11:50:02 AM		NESTED LOOPS									9	8	1	608	13	1274					
	7/17/2008 11:50:02 AM		TABLE ACCESS	FULL		JPS	FIN_STV	3		ANALYZED		10	9	1	608	13	1118					
	7/17/2008 11:50:02 AM		INDEX	UNIQUE SCAN		JPS	FIN_NAL_PK		UNIQUE	ANALYZED		11	9	2		15895	190740					
	7/17/2008 11:50:02 AM		TABLE ACCESS	BY INDEX ROWID		JPS	AN	4		ANALYZED		12	8	2	1	17074	443924					
	7/17/2008 11:50:02 AM		INDEX	UNIQUE SCAN		JPS	AN_PK		UNIQUE	ANALYZED		13	12	1		17074						


jps_test
	7/17/2008 11:47:41 AM		SELECT STATEMENT							CHOOSE		0										
	7/17/2008 11:47:41 AM		VIEW			JPS		1				1	0	1								
	7/17/2008 11:47:41 AM		WINDOW	SORT								2	1	1								
	7/17/2008 11:47:41 AM		WINDOW	SORT								3	2	1								
	7/17/2008 11:47:41 AM		WINDOW	SORT								4	3	1								
	7/17/2008 11:47:41 AM		VIEW			JPS		2				5	4	1								
	7/17/2008 11:47:41 AM		WINDOW	SORT								6	5	1								
	7/17/2008 11:47:41 AM		NESTED LOOPS	OUTER								7	6	1								
	7/17/2008 11:47:41 AM		NESTED LOOPS									8	7	1								
	7/17/2008 11:47:41 AM		TABLE ACCESS	FULL		JPS	FIN_STV	3				9	8	1								
	7/17/2008 11:47:41 AM		INDEX	UNIQUE SCAN		JPS	FIN_NAL_PK		UNIQUE			10	8	2								
	7/17/2008 11:47:41 AM		TABLE ACCESS	BY INDEX ROWID		JPS	AN	4				11	7	2								
	7/17/2008 11:47:41 AM		INDEX	UNIQUE SCAN		JPS	AN_PK		UNIQUE			12	11	1