Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple join conditions on indexed fields VERY slow...
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00901362
Message ID:
00901576
Views:
19
Darren,

>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

Since you are only selecting columns from barcodes, try rewriting it:
select b.* from barcodes b ;
   inner join detail d
   on b.po_num = d.po_num and b.style = d.style and d.wo_num = 123456 ;
   into cursor csrBcodes
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform