| Dilemma on Loading and querying. [message #184918] |
Fri, 28 July 2006 12:18  |
rkl1
Messages: 97
Registered: June 2005
|
Member |
|
|
Friends:
Here is my dilemma. We have 2 big partitioned tables over 150GB each. Every night tables are loaded and either we rebuild or recreate the indexes after loading done.And it takes time. Now users like to query these tables to longer hours so we can't start loading in future as done now.
It came to me that, we could copy the same two tables either in same or another schema (space is no problem) and then do the loading. And the original tables we will drop and make two materialized view with fast refresh option (logs included). so when users gone (mid night), we will run the refresh for the mviews which would get all the changes from the newly loaded tables. I wonder what about the indexes. Can we build bitmap type indexes on the mviews.
I wonder if there are other ideas we could pursue. The total loading and index making take around 6-8 hours.
Any help, assistance would be highly respected, and be remembered with appreciation for the long time.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
