Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

VirtualProvider performance

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.


Helpful Answer

Not what you were looking for? View more on this topic or Ask a question