Dear Friend,
Please checkout the scripts given in this site. It will help you. One of my query was working fine for the past two years and suddenly it was running for even two to three hours without output. I had taken the script from this site. And within 7 mins I got the data required.
Regards
Mohan
[font="Verdana"]Thanks
Chandra Mohan[/font]