Creating Database View on Fact Table with Dimension tables

View previous topic View next topic Go down

Creating Database View on Fact Table with Dimension tables

Post  vijaykodia on Fri Dec 12, 2014 11:28 am

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

View user profile

Back to top Go down

Re: Creating Database View on Fact Table with Dimension tables

Post  ngalemmo on Fri Dec 12, 2014 1:54 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum