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: Tue Aug 11 17:46:48 CDT 2020