Darren,

I've run into similar issues before.

What worked for me was that I broke my SQL statement into a few of them. This way each index used for optimization.

Using your statement:

select b.* from detail d join barcodes b on d.po_num = b.po_num and d.style = b.style where d.wo_num = 123456 into cursor csrBcodes

*Break this into :

select d.po_num as po_num_d,d.style as style_d from detail d where d.wo_num = 123456 order by 1 into cursor csrBcodes nofilter 

select csrBcodes.style_d,b.* from csrBcodes join barcodes b on csrBcodes.po_num_d = b.po_num order by 1 into cursor csrBcodes nofiler 

select csrBcodes.* from csrBcodes where style_d = style into cursor csrBcodes nofiler 

Hope this helps

Dawa

>hi,
>
>i'm attempting to join 2 fairly large tables (200,000 recs each) on multiple fields via:
>
>select b.* from detail d join barcodes b on d.po_num = b.po_num and d.style = b.style where d.wo_num = 123456 into cursor csrBcodes
>
>d.wo_num, d.po_num, d.style, b.po_num & b.style are all indexed, yet this query takes more than 30 secs. if i limit the join condition to a single field - either po_num OR style - the query runs in less than a second??!
>
>any thoughts? are multiple condition joins just slow??
>
>thanks in advance.