dimension table

From: Kar <kp0773@xxxxxxxxx>
To: Oracle-L@xxxxxxxxxxxxx
Date: Tue, 8 Dec 2009 11:17:05 -0800

All,

I am observing  the date dimension table is giving high cpu cost and on
explain table it seems to be a troubling spot .

I am looking for any suggestion on what would be a better approach for
designing this  table .

Appreciate any suggestions.

thanks
Prasad

Follow-Ups:
- Re: dimension table
  - From: Jared Still
- Re: dimension table
  - From: Kellyn Pedersen
- Re: dimension table
  - From: Greg Rahn

Other related posts:

» dimension table - Kar
» Re: dimension table- Jared Still
» Re: dimension table- Kellyn Pedersen
» Re: dimension table- Greg Rahn
» Re: dimension table- Kar
» Re: dimension table- Greg Rahn
» Re: dimension table- Tim Gorman
» Re: dimension table- Kar
» Re: dimension table- Greg Rahn
» Re: dimension table- Kar
» Re: dimension table- Wolfgang Breitling
» Re: dimension table- Tim Gorman
» Re: dimension table- Kar