speedup the query ~~

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

[Quoted] 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 CEST