i am just using select stmt from some view.
view defination is also selecting columns from inner join of 3 tables.
view count is about 46 millions records.
so while selecting from view it gives me:
Exception of type 'System.OutOfMemoryException' was thrown.
same error occur if i use direct select from those tables instead of select * from view.
What is the reason behind this.
Any help will be appreciated.
View Complete Post