Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OLAP query speed

648459Jul 10 2008 — edited Jul 15 2008

Hello,

I built an OLAP cube on a fact table of about 100,000 rows with dimension tables of around 600-1000 entries (mainly text like customer, product, and salesman). I'm wondering why the initial query (first query) would be much more slower (~10secs) than the subsequent queries (~0.5secs). I guess this has something to do with the caching of results but how can I control the caching such that even the first query would be fast as well?

Thank you,
GH

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 12 2008

Added on Jul 10 2008

#data-warehousing, #olap

15 comments

2,533 views