Fact Table Indexing Strategy

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?

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

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.

Sponsored content

Fact Table Indexing Strategy

Fact Table Indexing Strategy

For oracle

Re: Fact Table Indexing Strategy

Re: Fact Table Indexing Strategy