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
sriram
Messages: 58
Registered: September 2000
Member
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

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


Current Time: Wed Dec 07 03:34:31 CST 2022