This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
is it possible to get huge delay while fetching record on view?
A database view is the result of a [SQL] query. It can take the database several hours before returning the results of a query. So the answer to your question is yes, it is possible to get a huge delay while fetching a record on a view.