I only have access to Microsoft's SQL Server Management Studio, I have been informed that my OBDC connection looks correct.

I have been told that

"Typically there is an index 'table' that you have to join to for optimization. It isn't always obvious or exposed by the vendor, but they should be able to provide you direction."

Does this sound correct?

Thank you!!