Saturday, January 5, 2013

NOLOGGING In Oracle Databases

In Oracle there is a valuable feature where you can disable logging for only one table. In SQL Server maximum granularity you have is database level. So in case, you are doing lot of inserts or index rebuilding for only one table you have the option of disabling the logging for that table.


So above command will suspend the logging for table t1,

Only the following statements can make use of nologging:

Alter Table

  • Move Partition

  • Split Partition

  • Add Partition

  • Merge Partition

  • Modify Partition

Alter Index

  • Split Partition

  • Rebuild

  • Rebuild Partition

Create Table

Create Index

More info from following links

So I think it is good feature to have for SQL Server as well.

No comments:

Post a Comment