dimension table

From: Kar <kp0773_at_gmail.com>
Date: Tue, 8 Dec 2009 11:17:05 -0800
Message-ID: <39a33df90912081117o50b73308t2894712e9b3f707b_at_mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 08 2009 - 13:17:05 CST

This message: [ Message body ]
Next message: Jared Still: "Re: dimension table"
Previous message: Jared Still: "Re: Strange issue after patching to 10.2.0.4 CPU 24"
Next in thread: Jared Still: "Re: dimension table"
Reply: Jared Still: "Re: dimension table"
Reply: Kellyn Pedersen: "Re: dimension table"
Reply: Greg Rahn: "Re: dimension table"
Maybe reply: Wolfgang Breitling: "Re: dimension table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message