Re: Oracle Query-problem help wanted.

hdamz_at_hda.hydro.com writes in article <hdamz.10.000DAF26_at_hda.hydro.com>:
>
> Hello friends !!!
>
>
> I got a ORACLE SQL-problem that I am not able to resolve.
> The query is working but it takes about 30-40 minutes on 1200 rows.
>
>

Without knowledge which indexes (if any :-)) you use, there is only one tip:

try EXPLAIN PLAN on your statement and look what the system is doing to satisfy your query.

Willy Klotz

Willys Mail     FidoNet   2:2474/117  2:2474/118     Mail Only System
                CIS: 100020,3517       USR Courier HST dual standard
                willyk_at_kbigate.stgt.sub.org
                ->   No Request from 06.00 to 08.00 <-
======================================================================