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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 05:24:12 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.