Urgent: this oracle query is taking too much time for running, how to optimize

[janki_mehta]

whats the explain plan

QUERY_PLAN OTHER_TAG OTHER OBJECT_NAME

------------------------------------------------------- -------------------- ------------------------------ ------------------------------

SELECT STATEMENT

SORT ORDER BY

NESTED LOOPS

NESTED LOOPS

VIEW VW_NSO_1 VW_NSO_1

SORT UNIQUE

COUNT STOPKEY

VIEW

SORT GROUP BY STOPKEY

TABLE ACCESS BY INDEX ROWID WFRAUD_ WFRAUD_DATA

DATA



INDEX RANGE SCAN WFRAUD_DATA_TIME WFRAUD_DATA_TIME_CREATED

_CREATED



TABLE ACCESS BY INDEX ROWID WFRAUD_DATA WFRAUD_DATA

INDEX UNIQUE SCAN WFRAUD_DATA_NEW_PRIME WFRAUD_DATA_NEW_PRIME

TABLE ACCESS BY INDEX ROWID WFRAUD_DATA_EXTRA WFRAUD_DATA_EXTRA

INDEX RANGE SCAN WFRAUD_DATA_EXTRA_PK WFRAUD_DATA_EXTRA_PK



15 rows selected