Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Fact Table Indexing Strategy

3 posters

Go down

Fact Table Indexing Strategy Empty Fact Table Indexing Strategy

Post  bi_at_nj Sat Oct 31, 2009 12:41 am

Please explain the indexing strategy which is in use in your organisation for fact tables in your current database(oracle, sybase, db2)

Specify volume as the indexing strategy may be based upon the volume of data.

Is there a well laid out strategy for Indexing for fact tables?

If so, what is it we follow for Fact Tables in Oracle?
and
If so, what is it we follow for Fact Tables in Sybase?
and
If so, what is it we follow for Fact Tables in Db2?

bi_at_nj

Posts : 14
Join date : 2009-10-31

Back to top Go down

Fact Table Indexing Strategy Empty For oracle

Post  gerardnico Sat Oct 31, 2009 10:32 am

The star transformation is the best strategy to follow :
http://download.oracle.com/docs/cd/E11882_01/server.112/e10810/schemas.htm#CIHGHEFB
gerardnico
gerardnico

Posts : 15
Join date : 2009-08-02
Age : 49
Location : Netherlands

http://gerardnico.com/

Back to top Go down

Fact Table Indexing Strategy Empty Re: Fact Table Indexing Strategy

Post  BoxesAndLines Mon Nov 02, 2009 2:46 pm

You seem to have this idea that there is a one size fits all solution. Unfortunately, this is not the case. Yes, you should index. Yes, you should partition. Beyond that the rest is dependent on what you are trying to accomplish.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Fact Table Indexing Strategy Empty Re: Fact Table Indexing Strategy

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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