Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> speedup the query ~~

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US