Creating Database View on Fact Table with Dimension tables
2 posters
Page 1 of 1
Creating Database View on Fact Table with Dimension tables
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.
vijaykodia- Posts : 1
Join date : 2014-12-12
Re: Creating Database View on Fact Table with Dimension tables
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.
Similar topics
» Relationship between view-dimension and fact table
» How do I join a role playing date dimension view with a Fact table in SQL Server?
» Relationship between fact table and dimension tables
» Best practise in creating fact tables for health care
» How do I join a role playing date dimension view with a Fact table in SQL Server?
» Relationship between fact table and dimension tables
» Best practise in creating fact tables for health care
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum