Creating Database View on Fact Table with Dimension tables

[vijaykodia]

Is it good idea to get max date data from a Fact table joining one dimension v/s creating materialized view? What happens if there is bit map index on a fact table if data is not retrieved directly on Fact Table but instead fetch data by creating database view? The question is query max date data directly using Fact Table joining Dimension tables or create database view and use database view to create materialized view to query further.

[ngalemmo]

Just query the table. If you find there are performance issues and it is a frequent query, then start considering alternatives. There are a lot of ways to deal with it depending on use cases you will encounter.