We are on HANA version Hana1SP12(on premise) We have defined a remote table based using Smart Data Access Odata url. We connect to SAP C4C instance to fetch data. We want to do a initial load of a table which has 200k rows. When I do a select * from the remote table it takes lot of time and I have to cancel the query. The select statement works well for a smaller subset of rows ( 100 rows).
Is there any performance tuning option / Best practice we can use in HANA to fetch large rowsets from SDA remote data source.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.