I had a view which use to fetch lakhs of records to be displayed in a SSRS report, but it aborts since the amount of data is too much to be processed, hence came the question of performance in picture. The same applies to me with Oracle, though I got a solution for Oracle I am looking for something similar in SQL Server.
Oracle provides BULK COLLECT as one of the option to improve performance, i.e. In a stored procedure first of all I need to define a cursor, Open the cursor using BULK COLLECT option and fill it in a Global Temp table. From this temp table I can fetch records and display it on report.
I am looking for similar functionality in SQL Server.