Home » SQL & PL/SQL » SQL & PL/SQL » Attributes
Attributes [message #251433] Fri, 13 July 2007 10:16 Go to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

Is anybody can please tell me what is the basic difference between Logging and no logging OR
Compress and no coompress, if i include any one these attribute in tablespace for creating table and for creating index.

Thanks in advance

[Updated on: Fri, 13 July 2007 10:30]

Report message to a moderator

Re: Attributes [message #251440 is a reply to message #251433] Fri, 13 July 2007 11:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is clearly explained in the documentation.
Put the words in the search field and you get the answer.

Regards
Michel
Re: Attributes [message #251466 is a reply to message #251433] Fri, 13 July 2007 13:07 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
qasim845 wrote on Fri, 13 July 2007 09:16
Is anybody can please tell me what is the basic difference between Logging and no logging OR
Compress and no coompress, if i include any one these attribute in tablespace for creating table and for creating index.

Thanks in advance





Nologging can be used to minimize the amount of redo generated.Logging is opposite.

Compression, a feature introduced in Oracle9i Database Rel 2, can compress entire tables, table partitions, and materialized views. It will drastically reduce the disk space and buffer cache requirements, and in many cases improve query performance, especially on I/O bound systems. Compression is targeted at decision support and OLAP applications, but others may experience great benefits as well.



http://www.oracle.com/technology/oramag/webcolumns/2003/techarticles/poess_tablecomp.html
Previous Topic: Pivot in Oracle
Next Topic: Unique constraints
Goto Forum:
  


Current Time: Mon Dec 05 03:06:02 CST 2016

Total time taken to generate the page: 0.05939 seconds