Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> speedup the query ~~
[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