Hi All

I have a query that I am using to import data for an old system. It
seems very slow and I was hoping that someone could tell me why? I am using ASA vs 7.03.

insert into trans_scale (
rcode,
transid,
siteno,
year,
inout,
random,
freqcode,
scalefreq)
select
t.rcode,
t.recno,
t.siteno,
t.year,
t.inout,
COALESCE (c.random,0),
(case
when c.company = 'Y' then 'BC'
when c.state = 'Y' then 'ST'
when c.USFS = 'Y' then 'FS'
when c.other = 'Y' then 'OT'
else 'NS'
end),
0
from ctrans as c, trans as t, csource as s
where t.ticket = cast(c.ticket as integer)
and t.source = s.srcode
and c.source = s.source
These are not large tables
trans and ctrans have about 80,000 rows
csource has about 50.

Thanks