Re: UPDATE

From: agis <stag_at_hq.acn.gr>
Date: Thu, 3 Feb 2005 10:05:20 +0200
Message-ID: <ctsqkm$25cu$1@ulysses.noc.ntua.gr>

Well, if i remove the index hint it dows a full partition scan on tvbill_cisco_cdrs.

I think that because i update with ranges of dates is usefull to use the index.

There is always a matching row selected from table b in table A. And is possible the rows to be more than one thats why i use the rownum.

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:1107359372.948386.250130_at_o13g2000cwo.googlegroups.com...
> What?
>
> First, of all if you remove the index hint what does the explain plan
> look like and how long does it take to run?
>
> Second, what happens to the table A columns when there is no matching
> row returned by the coordinated subquery or is there always a matching
> row? You may need to add an EXISTS condition to the outer query.
> HTH -- Mark D Powell --
>
Received on Thu Feb 03 2005 - 02:05:20 CST