speedup the query ~~

From: feib <agi_at_feib.com.tw>
Date: 2000/04/26
Message-ID: <MPG.136fd7902753f451989687@news.gcn.net.tw>#1/1

[This followup was posted to comp.databases.oracle.tools and a copy was sent to the cited author.]

Hello,everyone

I have two tables A,B (A 2,000 records, B 600,000 records)

table A look like follows

    Name                            Null?    Type


 ------------------------------- -------- ----

 BRNO                                     NUMBER(3)
 UNINO                           NOT NULL VARCHAR2(11)     -------PK
 ZIPCD                                    NUMBER(5)
 ADDR                                     VARCHAR2(72) 

   table B look like follows 
 Name                            Null?    Type


 ------------------------------- -------- ----

 UNINO                           NOT NULL VARCHAR2(11)      -------PK
 BRNO                                     NUMBER(3)
 CADRZIPCD                                NUMBER(5)
 COMMADR                                  VARCHAR2(62)

select a.brno, a.unino, a.addr, b.commadr from tableA a, table B b
where a.unino=b.unino
/

How to rewrite to speed up the query ??

Best Regards,
Agi Chen Received on Wed Apr 26 2000 - 00:00:00 CDT