[Q] Split Large Table ? and some more ...
Date: 1996/09/03
Message-ID: <322CD8B8.2971_at_hotmail.com>#1/1
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.
--Received on Tue Sep 03 1996 - 00:00:00 CEST
---------------------------------------------------
How HIGH You go depends on How DEEP Your Roots are.
---------------------------------------------------
Keyoor Anant Brahme