Fact Table Indexing Strategy

View previous topic View next topic Go down

Fact Table Indexing Strategy

Post  bi_at_nj on 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

View user profile

Back to top Go down

For oracle

Post  gerardnico on 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
avatar
gerardnico

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

View user profile http://gerardnico.com/

Back to top Go down

Re: Fact Table Indexing Strategy

Post  BoxesAndLines on 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.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Fact Table Indexing Strategy

Post  Sponsored content


Sponsored content


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