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

Oracle LazyDBA home page