Re: [Q] Split Large Table ? and some more ...

I would agree with this suggestion if you were running v.7.3 - one of the new features in it accelerates performance of a 'union all' statement - which is what you would do to construct a view to include the ten smaller tables.

Regards,
jh

Keyoor wrote:
>
> Date : 03/09/1996
> Ref : news3.txt
>
> Hi folks !
>
> I (novice DBA) am facing some problem regarding my Tables because
>
> -------------------------------------------------------------------
> Table No of Records Operations on these tables
> -------------------------------------------------------------------
> 1 2 million Select,Insert,Update
> 2 1.4 million Select,Update
> 3 70,000 Select
> -------------------------------------------------------------------
>
> The data in these tables have been populated using SQL*Loader. Now I need
> to run 5 Stored procedures in which above operations are done on the
> table. I have already done the needful i.e.
> a. Built correct indexes,
> b. SQL Optimiztion using hints.
> Is there anything more to do ?
>
> My colleuges suggest I split those table up into 10 separate pieces. Will
> it make the code run fast ? I'm using Oracle 7.2.3.3 on HP/UX.
> Also, I have to give an estimate of time required to run the whole show.
> Has anybody run this kind of job before ? What would the time required for
> the job to finish ? Can I estimate the time using only 1000 records ?
> Or will Oracle performance down-grade with increase in the records ?
>
> Any suggestions ? Please send a CC to my e-mail address also.
>
> Thanx in advance.
>
> Keyoor.
>
> --
> ---------------------------------------------------
> How HIGH You go depends on How DEEP Your Roots are.
> ---------------------------------------------------
> Keyoor Anant Brahme
  Received on Thu Sep 05 1996 - 00:00:00 CEST