We tried to perform SELECT * on HANA table in Studio. Table has 200K records and approx. 200 columns. Query executed in ms. Draw result set is running for ever. I noticed that it is consuming all my laptop memory and after few mins, it reaches to 100% consumption. We've same table on SQL server and when user runs same query on SQL server, he gets entire o/p in approx. 7 mins.
It seems like HANA studio is not the correct tool to perform SELECT for huge dataset. We tried TOAD, it is taking approx. 9 mins to return entire dataset.
Users are not adopting HANA due to poor performance with data display for huge dataset compared to SQL server.
Has anyone come across similar issue? What is the correct tool for ad-hoc analysis in such scenario?