Home » RDBMS Server » Server Administration » Table compression (Oracle 11gr2,Linux 6)
Table compression [message #601962] Wed, 27 November 2013 19:33 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

Could you tell me which is the one that will delete the duplicate values and compress the data ?

1.Table compression.

2.Table defragmentation.

Thanks
Re: Table compression [message #601963 is a reply to message #601962] Wed, 27 November 2013 19:56 Go to previous messageGo to next message
BlackSwan
Messages: 22495
Registered: January 2009
Senior Member
Jack14 wrote on Wed, 27 November 2013 17:33
Hi,

Could you tell me which is the one that will delete the duplicate values and compress the data ?

1.Table compression.

2.Table defragmentation.

Thanks


Are you unable or unwilling to run test cases to learn the answer yourself?

By the way, how does brain dead software actually determine which records should be classified as duplicate values?
Re: Table compression [message #601964 is a reply to message #601963] Wed, 27 November 2013 22:54 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Quote:
By the way, how does brain dead software actually determine which records should be classified as duplicate values?


Only you should be knowing it.
Re: Table compression [message #601966 is a reply to message #601964] Wed, 27 November 2013 23:09 Go to previous messageGo to next message
BlackSwan
Messages: 22495
Registered: January 2009
Senior Member
Jack14 wrote on Wed, 27 November 2013 20:54
Quote:
By the way, how does brain dead software actually determine which records should be classified as duplicate values?


Only you should be knowing it.


HUH?

I have no input or impact when you do either table compression or table defragmentation.

What is duplicate for you may not be duplicate for me.
If every table has PK, then by definition no duplicates exist.
In a well designed application, duplicate records NEVER exist.
Re: Table compression [message #601968 is a reply to message #601962] Wed, 27 November 2013 23:57 Go to previous messageGo to next message
Lalit Kumar B
Messages: 1816
Registered: May 2013
Location: World Wide on the Web
Senior Member
Jack14 wrote on Thu, 28 November 2013 07:03
Could you tell me which is the one that will delete the duplicate values and compress the data ?

1.Table compression.

2.Table defragmentation.


I don't know much about the defragmentation technique. However, advance table compression in 11g works well as publicized by Oracle. It is specially designed for the OLTP tables and works at block level. You can make use of the "Oracle Advanced Compression Advisor" package.

A good read for you.
Re: Table compression [message #601980 is a reply to message #601968] Thu, 28 November 2013 01:42 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thanks a lot. Useful as well.
Previous Topic: Table Change Detection - Databases
Next Topic: Migrating MS SQL into Oracle database
Goto Forum:
  


Current Time: Fri Jul 25 04:21:59 CDT 2014

Total time taken to generate the page: 0.10253 seconds