Home » RDBMS Server » Server Administration » Extremely Large Databases - Indexes?
Extremely Large Databases - Indexes? [message #49821] Tue, 12 February 2002 02:52 Go to next message
shiva
Messages: 38
Registered: March 2001
Member
I have a billion+ row table that is rebuilt from scratch every week.
If I have indexes on it slows down the load, but I use this fact table to build other tables in my DW.

The fact table is partitioned by week#.

What is the best option for both quick loads and aggregate builds?
1. Have no indexes at all.
2. Create the index after the data load
3. Leave indexes as it is.

Thanks,
Shiva.

Report message to a moderator

Re: Extremely Large Databases - Indexes? [message #49829 is a reply to message #49821] Tue, 12 February 2002 10:11 Go to previous messageGo to next message
INTROV
Messages: 20
Registered: February 2002
Junior Member
Drop the indexes before the dataload. After the dataload is complete, recreate the indexes.

Report message to a moderator

Re: Extremely Large Databases - Indexes? [message #49834 is a reply to message #49821] Tue, 12 February 2002 14:08 Go to previous messageGo to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
why do you rebuild it each week?
Is it not possible to just add a new partition with the new data?

Report message to a moderator

Re: Extremely Large Databases - Indexes? [message #49847 is a reply to message #49821] Wed, 13 February 2002 07:25 Go to previous message
shiva
Messages: 38
Registered: March 2001
Member
No, The data might have changed (more than 10%) due to corrections at the source.

Report message to a moderator

Previous Topic: Re: lookin for some test papers for OCP exams
Next Topic: Oracle9i: DB_CACHE_SIZE [Newbie ?]
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 11:17:44 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.