I do not think you can fix these kinds of problems without a thorough
investigation as to the kinds of queries and the structures of the data
tables and then how you construct the query code. You might even need to
incorporate materialized views. Try using Oracle Discoverer and get some
insight into what the solutions might be.

Regards
Amin Adatia ([Email address protected]
KnowTech Solutions Inc. (www.knowtech.ca)
(613) 226-8378 Mobile (613) 864-8378
----- Original Message -----
From: "Sandeep" <oracledba-ezmlmshield-x44137110.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Saturday, December 29, 2007 4:40 AM
Subject: Data warehouse


> hello there
>
> i am working with Marketing department playing an analyst role, and yes i
> am a newbie stepping into part of DBA oracle and hopping that you gurus
> will help me .
>
> On daily basis we will be getting subscriber base and this needs to be
> loaded into oracle database its volume/size 202 MB is around 17 lacs rows
> of data for this what are the optimal indexes to be created,partitions to
> be made,how to tune this large table so that we will have faster response
> with minimal time.
>
>
> We need to know is it possible to load the data faster other than SQL
> Loader Utility.
>
>
>
>
>
> Regards
> sandeep Landge
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>


Oracle LazyDBA home page