Home » RDBMS Server » Performance Tuning » Datawarehouse query
Datawarehouse query [message #121106] Thu, 26 May 2005 02:15 Go to next message
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
Re: Datawarehouse query [message #121161 is a reply to message #121106] Thu, 26 May 2005 10:15 Go to previous messageGo to next message
Art Metzer
Messages: 2478
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.
Re: Datawarehouse query [message #121204 is a reply to message #121106] Thu, 26 May 2005 17:37 Go to previous messageGo to next message
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.
Re: Datawarehouse query [message #121211 is a reply to message #121204] Thu, 26 May 2005 20:41 Go to previous message
well_rbs
Messages: 3
Registered: May 2005
Location: Delhi
Junior Member
Yes it is true star schema.

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


Current Time: Tue Sep 29 13:03:11 CDT 2020