Dimension Table Indexing Strategy

bi_at_nj · bi_at_nj on Fri Oct 30, 2009 9:44 pm

Please tell me what kind of indexes you are using in your dimension tables in your organization.

I am looking for dimension tables indexing strategy for Sybase, Oracle and Db2.

If you have any indexing strategy document for Dimension tables for Oracle, sybase and Db2 that would be helpful.

- Thanks in advance,
nj_at_bi

gerardnico · gerardnico on Sat Oct 31, 2009 7:29 am

Her a documentation on Index in a datawarehousing environment :
http://download.oracle.com/docs/cd/E11882_01/server.112/e10810/indexes.htm#i1004902

Dimension Table Indexing Strategy

Dimension Table Indexing Strategy

For Oracle