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

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


Dimension Table Indexing Strategy

2 posters

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

Dimension Table Indexing Strategy Empty Dimension Table Indexing Strategy

Post  bi_at_nj Sat Oct 31, 2009 12:44 am

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

bi_at_nj

Posts : 14
Join date : 2009-10-31

Back to top Go down

Dimension Table Indexing Strategy Empty For Oracle

Post  gerardnico Sat Oct 31, 2009 10: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
gerardnico
gerardnico

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

http://gerardnico.com/

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

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