I have created a VirtualProvider on a SQL Server datasource.
I have written a query with a restriction, but it fails to complete - it is trying to build an internal table for all 1.4 million rows.
I have created an index on the restricted column, but it appears to want to pull all the records over before filtering.
Is this correct?
Is it possible to alter this behaviour?
I have tried monitoring the SQL in transaction RSRT but it will not show the query or run schedule.