On Tue, Jan 04, 2005 at 01:31:45PM -0800, sarlav kumar wrote:
> Hi,
>  
> The query just returns "0 rows".
> What else could be the problem?
>

You don't have statistics tracking turned on in your database.

Do a ps on the server, look for 'idle in transaction' processes.
 
-- 
"Democracies survive only until the voters discover that they can vote
themselves largesse from the public treasury ..." -- Alexander Tyler