Performace of query vs View
885267Aug 29 2011 — edited Aug 31 2011Hi,
I use a query to join 2 tables which will result in close to 1.5 million rows .
I created a view based on this query to return only 60K rows (based on effective date concept in Peoplesoft)
I read this view from my programming language (ex. java )
How is the performance when comparing the view to the actual query ?
is view better than query ?
In my case i need to read data in a subroutine ( multiple function calls to get this data so i hit the view many times) which is better view or query ?
any information is appreciated.
Thank you,
Amit