Hi Friends,
I justed wanted to tell u one thing that values in status column in USERS table in not the same in status column in listings_new table.

The explain plan is as below

Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=6491 Card=1 Bytes=37
)

1 0 SORT (AGGREGATE)
2 1 NESTED LOOPS (Cost=6491 Card=24126 Bytes=892662)
3 2 REMOTE* (Cost=25 Card=53 Bytes=795) LINK_D
B

4 2 TABLE ACCESS (BY INDEX ROWID) OF LIST_NEW
' (Cost=122 Card=45520 Bytes=1001440)

5 4 INDEX (RANGE SCAN) OF 'LIST_NEW' (NON
-UNIQUE) (Cost=10 Card=45520)



3 SERIAL_FROM_REMOTE SELECT "USER_ID","STATUS" FROM "U
SERS" "USERS" WHERE "STATUS"