I created a materialized view which significantly sped up
select * from table
query above. After, I dropped materialized view, this query is still returning records as fast as with materialized view.
I used drop materialized view viewname
query to drop MV. Do I need to do anything else to return table to previous state ?