QUOTE (dave @ Jan 8 2008, 11:17 AM)
how do you know its hanging and not actually just doing its work
May be you are right, but this query never returned any result after waiting a long time, while underlying table has only 377 records.
Further more, this view selects rows from a database on remote site, connected on E3 lines. I monitored network it looks fine.
Can you please suggest some ways to find where the problem is ???