RE: expensive SQL
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <bnsarma@xxxxxxxxx>
- Date: Fri, 10 Mar 2006 01:03:29 +0100
Hi
> I see the following SQL from the Developer,
>
> select * from max_update where rowid in
> (select max(rowid) from vrcdba.max_update group by request_id )
> and request_id not in (select request_id from max_update where server
> ='cas1');
>
> Takes for ever
You should ask the developer what is the aim for such a query. Honestly, I
don't see how it could be useful!
Chris
Other related posts:
