Hi

Try posying the exaplian plan at least

Give this a try

SELECT COUNT(*)
FROM LISTINGS_NEW ln ,users u
WHERE STATUS = 'A' and
IMAGE_ID > 0 and
END_TIME > sysdate AND
ln.user_id=u.user_id

regards
Hrishy