Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I speed up my SQL joins when I use the PFXodbc Driver?

April 26, 2017driver joins pfxodbc speed sql

0

Posted

How do I speed up my SQL joins when I use the PFXodbc Driver?

1 Answer

0

Posted

SQL joins are generally quite slow. The speed of SQL joins mostly depends on the query optimizer. Generally, if the joined fields are indexed, the join is faster. You can also experiment with reordering the SQL statement, until you find an order that is faster. (This again depends on the query optimizer).