In SQL Server is it possible to create an update inner join
without use of slow IN or EXIST.

In postgresql is it possible?

--

Paolo Holzl wrote:

using also a subselect il slow.

Example

update Tab1 b set FieldToUpdate = a.OtherField where exists
(select a.Key, a2.key from a
where a.key=b.key and a.key2=b.key2)

work but is slow

--

Paolo Holzl wrote:

using also a subselect il slow.

Example

update Tab1 b set FieldToUpdate = a.OtherField where exists
(select a.Key, a2.key from a
where a.key=b.key and a.key2=b.key2)

work but is slow

--

Paolo Holzl wrote:

using also a subselect il slow.

Example

update Tab1 b set FieldToUpdate = a.OtherField where exists
(select a.Key, a2.key from a
where a.key=b.key and a.key2=b.key2)

work but is slow

--

Paolo Holzl wrote:

using also a subselect il slow.

Example

update Tab1 b set FieldToUpdate = a.OtherField where exists
(select a.Key, a2.key from a
where a.key=b.key and a.key2=b.key2)

work but is slow

--

Paolo Holzl wrote:

using also a subselect il slow.

Example

update Tab1 b set FieldToUpdate = a.OtherField where exists
(select a.Key, a2.key from a
where a.key=b.key and a.key2=b.key2)

work but is slow

--

Paolo Holzl wrote:

using also a subselect il slow.

Example

update Tab1 b set FieldToUpdate = a.OtherField where exists
(select a.Key, a2.key from a
where a.key=b.key and a.key2=b.key2)

work but is slow

--

Paolo Holzl wrote:

using also a subselect il slow.

Example

update Tab1 b set FieldToUpdate = a.OtherField where exists
(select a.Key, a2.key from a
where a.key=b.key and a.key2=b.key2)

work but is slow

--

Paolo Holzl wrote:

using also a subselect il slow.

Example

update Tab1 b set FieldToUpdate = a.OtherField where exists
(select a.Key, a2.key from a
where a.key=b.key and a.key2=b.key2)

work but is slow

--

begin Paolo Holzl schrieb:
wrong syntax. Please show us a correct example and ...

show us the output generated from explain analyse <your query>.

My guess: you haven't proper indexes.



end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net