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@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

                                                            UpdB

2105 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

Received on Wed Nov 03 1999 - 06:20:15 CST