How to speed up this query?
From: Alex Sharifi <surfer_at_carser.adminsrv.emich.edu>
Date: 1996/02/22
Message-ID: <4ggn0i$ch0_at_orphan.emich.edu>#1/1
Date: 1996/02/22
Message-ID: <4ggn0i$ch0_at_orphan.emich.edu>#1/1
I'm executing an embedded sql statement that just takes forever.
select distinct view1.i_mfr_id, view1.i_mfr_des,
view1.c_code, tablex.c_code
from view1, tablex
where view1.c_code = tablex.c_code;
I know that the 'distinct' directive is the "killer" here. Any way to optimize this?
Appreciate any help....Alex Sharifi Received on Thu Feb 22 1996 - 00:00:00 CET