OraFAQ Forum: Performance Tuning » Datawarehouse query

Home » RDBMS Server » Performance Tuning » Datawarehouse query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Datawarehouse query [message #121106]

Thu, 26 May 2005 02:15

well_rbs
Messages: 3
Registered: May 2005
Location: Delhi

Junior Member

Hi、

We have Data warehouse system. This is on Oracle 9i. We have a massive data on that system. Couple of tables consists of around 20,000,000 records. Now there are queries, which required joining these tables. Do you have any idea how do I improve these table structures to improve fetching of data. We are ready to implement any solution.(E.g Partition table or indexes)

Does anybody have any experience on this?

Thanks a lot.

Regards,
Rajesh

Report message to a moderator

Re: Datawarehouse query [message #121161 is a reply to message #121106]

Thu, 26 May 2005 10:15

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

Is it a true data warehouse, with a star schema (fact and dimension tables)?

You'll definitely want to read the Oracle 9i Data Warehousing Guide.

Report message to a moderator

Re: Datawarehouse query [message #121204 is a reply to message #121106]

Thu, 26 May 2005 17:37

DMcG
Messages: 51
Registered: May 2005
Location: Auckland, New Zealand

Member

If you give us the structure of the tables and what your queries look like then we may be able to help.

Report message to a moderator

Re: Datawarehouse query [message #121211 is a reply to message #121204]

Thu, 26 May 2005 20:41

well_rbs
Messages: 3
Registered: May 2005
Location: Delhi

Junior Member

Yes it is true star schema.

Thanks.

Report message to a moderator

Previous Topic:	All "Rows" equal 0 in TKPROF. Is this a setting?
Next Topic:	What are the steps to tune a query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 06:24:20 CST 2025