SQL Expert Question
From: Joao Ricardo B Oliveira <jricardo_at_ipb.pt>
Date: Wed, 3 Nov 1999 12:20:15 -0000
Message-ID: <7vp893$i11$1_at_pan.ipb.pt>
Hi there:
F1
F2
UpdA
Date: Wed, 3 Nov 1999 12:20:15 -0000
Message-ID: <7vp893$i11$1_at_pan.ipb.pt>
Hi there:
Anyone can tell me what's the fastest way to UPDATE UpdA from table A, with the data from Field UpdB from Table B.
The two tables are almost equal and the inner join columns are Id1, Id2, Id3, but in the Table B the primary key is a Sequence column.
If i create an index (Id1, Id2, Id3) im table B it will be faster isnt it ?
How can i use the INDEX in the UPDATE sentence ?
Table A
Id1 * Id2 * Id3 *
F1
F2
UpdA
Table B
Id1
Id2
Id3
F2
UpdB
Table A
UpdA Pos UPDATE Data 2105 1002 67 690 ... ... 1 1 ..... 6503 1002 67 690 ... ... 1 1 6643 1002 67 690 ... ... 1 2 6951 1002 67 690 ... ... 1 2
Table B
UpdB2105 1002 67 690 ... ... 1 .....
6503 1002 67 690 ... ... 1 6643 1002 67 690 ... ... 2 6951 1002 67 690 ... ... 2
(*) primary key
Please MAIL ME !!!
- Joao Ricardo B Oliveira jricardo_at_ipb.pt -
- Oracle DBA http://www.ipb.pt/~jricardo