Will Oracle use materialized view if I select count(*) from original table?

1
votes

If I create materialized view my_view as select * from my_table group by my_column Will Oracle use materialized view when I select count(*) from my_table?

1
oracle11gmaterialized-views
Check the execution plan you you will see. – a_horse_with_no_name
I have not done this yet, if it uses then I will create view. – Giorgi Orvelashvili

1 Answers

0
votes

No, It will not use materialized view.