Re: can i execute this sql ?

From: Jens Schauder <jens.schauder_at_opal-edv.com>
Date: Fri, 29 Oct 1999 02:11:35 -0700
Message-ID: <381964C7.F0EA0C60@opal-edv.com>

At first glance the sql-statement looks fine and if you don't get an error it should work.

If the tables are realy big it might take a while to complete.

If it takes to long for your purpose consider creating indices on the columns used in the where clause.

Jens

newnewbie_at_my-deja.com wrote:
>
> String str1= "select e.state_name, fwm.job_type, fc.fit_ind, count
> (*) from EMPLOYER_MASTER e, " +
> " FOREIGN_WORKER_MASTER fwm, FW_CERTIFIED_DETAILS fc "+
> " where fwm.employer_code = e.employer_code and " +
> " fc.worker_code = fwm.worker_code group by e.state_name,
> fwm.job_type, fc.fit_ind " ;
>
> the code for my sql is as above.
>
> can i execute it ?
>
> when i try, the program just hangs. perhaps there is too many records ?
>
> thanks, bye.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 29 1999 - 04:11:35 CDT