does dropping materialized view deletes all indexes and data used to speed up queries?

507 views Asked by At

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 ?

0

There are 0 answers