I have a MySQL server linked in SQL Server and I can query it like this:
select * from [MYSQL]...[table] where [column] = 1
this works, but if the table contains many rows performance drops, even if
column is indexed in MySQL.
I understand that generally speaking a distributed query cannot make use of remote indexes and optimizations, while
OPENQUERY does, but here I cannot use
OPENQUERY since queries are generated from a JavaEE JPA application.
Question is: are there any OLE DB Providers for MySQL which can take advantage of remote indexes, or is it just not supported at all by distributed queries?