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 Apr 20 06:28:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.