I have a table which get new records inserted every hour. From this tables am taking aggregation of some columns in a query which takes around 5 sec to complete. Wanted to create View which has this query result and the same need to update every hour.
Followed as in below link but am the data is not updating in vie wproperly.
Can anyone guide me plz. Thanks in Advance.