Home » SQL & PL/SQL » Client Tools » Slow about join
Slow about join [message #25942] Wed, 28 May 2003 00:37 Go to next message
happyhero
Messages: 10
Registered: April 2002
Junior Member
Hi
How are you! I met the question and need your help.
there are two tables A and B.
table A fields: af1 ,af2 ,af3;
table B fields: bf1 ,bf2 ,bf3;
relation condition:
A.af1 like b.bf2 || '%'.
table A have 1000000 records every day.
table B have 4000 records.
in result:
insert table temp from
select a.af2, b.bf2 from
a left join on a.af1 like b.bf2 || '%';
It need 4 minute when to select one minute data.
this is slow.
How do i?
is it possible that when a's record get the first relation record from b then return?
Please help me! thanks!
Re: Slow about join [message #25952 is a reply to message #25942] Wed, 28 May 2003 06:40 Go to previous messageGo to next message
Phenoracle
Messages: 35
Registered: March 2001
Member
There are many ways around your issue
One you could look at Pl/Sql as a solution to break up your transaction into small ones.

Also is b.bf2 unique if not an in-line view could of help.

Have fun Phenoracle

Re: Slow about join [message #25967 is a reply to message #25952] Wed, 28 May 2003 19:27 Go to previous message
happyhero
Messages: 10
Registered: April 2002
Junior Member
thanks.
b.bf2 is unique for table a.
I am testing speed with Pl/Sql. but I think it is same speed with single sql.

thanks again.
wangyong.
Previous Topic: How to pass SQL "create DIRECTORY TMP_DIR as 'c:\courses\cs601'" in Java to Oracle?
Next Topic: character conversion error 24365
Goto Forum:
  


Current Time: Tue Aug 04 15:07:22 CDT 2020