Search results
-
H
Speed tremendously affected by JOIN
I have a query that uses several LEFT JOINs to gather all its data from various lookup tables. However, oneof the criteria fed into that query is performing extremely poorly. Setup: [Products] with ProductID as PK, has 50000 records [ProdSuppls] with ProductID+SupplierID as PK, has 80000...