Home » RDBMS Server » Performance Tuning » Partitioning of tables need sugession
Partitioning of tables need sugession [message #134284] Wed, 24 August 2005 03:34 Go to next message
ashishodia
Messages: 10
Registered: August 2005
Location: Mumbai
Junior Member

Hi All,

I have four table having large amount of data
1. Cs_case 3450000
2. Case_details 3254140
3. cu_address 3254140
4. Cu_Pors 3200000

Some downloading proces and reports are very slow in system so i want to partition these tables
plz suggest me this will increase peformance of system and which partition i have to use


thanx
Re: Partitioning of tables need sugession [message #134302 is a reply to message #134284] Wed, 24 August 2005 04:25 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
yes, its will increase the performance. As for which partition to use, you have a number of options like range, list & hash partitioning.

For details this url might help:
http://www.stanford.edu/dept/itss/docs/oracle/9i/server.920/a96521/partiti.htm#2165

Regds
Girish
Previous Topic: Users and default optimizer_mode
Next Topic: how to figure out checkpoint running slow
Goto Forum:
  


Current Time: Mon Nov 28 05:57:08 CST 2022