[ZVV]

На SalesTable

SELECT * FROM SalesTable USING INDEX SalesIdx

На SalesLine

SELECT * FROM SalesLine USING INDEX SalesLineIdx 
WHERE SalesTable.SalesId=SalesLine.SalesId 
JOIN * FROM InventDim 
WHERE SalesLine.InventDimId = InventDim.inventDimId