Hi Friends,
Can you please help me in tuning the below sql..
I tired lot of option but no sucess.
I am runing oracle 8.1.7.4, sun solars 5.6
SELECT COUNT(*) FROM LISTINGS_NEW WHERE STATUS = 'A' and IMAGE_ID > 0 and END_TIME > sysdate AND
user_ID IN ( SELECT user_ID FROM USERS WHERE STATUS = 'A' )
here user_id is indexed
regards
anandkl