I created view with 4 tables by joining primary key of the all the tables.
when I access the view by select query . it gets very slow to fetch the records.
view has more than 1 Lack records. but if I create a table with View data, while selecting table data it is fetched fastly .
I need to get the data from the view fastly.
How can we do that???