Thank you Michael and WayneS for the replies.

Actually i've written a large query in a view which fetches almost 1million records.

and if I apply filters to that query then that...