Home » Developer & Programmer » Data Integration » question on local indexes using partitions
question on local indexes using partitions [message #93171] Wed, 21 May 2003 14:07
Messages: 58
Registered: September 2000
I have a large Fact table for my data warehouse. It has a bunch of local indexes for each of the partitions.

Is there a way to disable a local index and still load data into this partition using insert statements in Oracle 9i? This way it takes less time to load the data.Any syntax will be helpful

Previous Topic: Yahoo! Inc (Sunnyvale, Calif) - Data Warehousing Employment Opportunities
Next Topic: Estimating the size of a DW
Goto Forum:

Current Time: Sat May 18 10:37:19 CDT 2024