Re: help me to improve sql, plz

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Wed, 20 Feb 2002 23:02:57 GMT
Message-ID: <3C742B33.C22B6BBD@ci.seattle.wa.us>

If you had actually provided some SQL someone could. What is this?

Are you selecting any fields? Doing any aggregations? Using any functions? Linking an unending list of tables? Connecting the tables via what fields?

Daniel Morgan

Alexei Fedotov wrote:

> could you help me to improve sql
>
> select
> ...
> from ir, gw, ...
> where
> ...
> and (ir.figw_src in (select figw_id from gw) or ir.figw_src is null)
> and ir.figw_src = gw.figw_id (+)
Received on Wed Feb 20 2002 - 17:02:57 CST