Re: data load and query VLDB

soalvajavab1_at_yahoo.com wrote:
> can you highlights key things required to load and retrieve very large
> data sets? Oracle 9i on UNIX

That is a whole topic. It depends on the purpose of the application (warehouse, OLTP, etc.), how much data

Start with the performance guide at tahiti.oracle.com, as well as the concepts guide depending on your background.

For loading a large amount of data, but you may want read up on things like NOLOGGING if you can afford to load a large amount of data and either lose it, or can back it up immediately after the load. Read up on SQL*LOADER, as well.

For querying (retrieving), it's all about design. Are your tables normalized properly (once again, this depends on if it is a warehouse or OLTP), are they indexed properly, should they be partitioned, are the queries efficient, is the disk subsystem optimized, etc., etc., etc.

Sorry I can't be more specific, but Oracle is an enormous beast, with tons of functionality that can be matched together with great success, or pasted together with...no so great a success :)

HTH, Steve Received on Wed Jan 03 2007 - 08:58:30 CST