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
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

Re: Partitioning of tables need sugession [message #134302 is a reply to message #134284] Wed, 24 August 2005 04:25 Go to previous message
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:

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