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.
ALTER TABLE t1 NOLOGGING;
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
http://www.orafaq.com/wiki/Nologging_and_force_logging
http://www.adp-gmbh.ch/ora/misc/nologging.html
http://www.dba-oracle.com/t_nologging_append.htm
So I think it is good feature to have for SQL Server as well.
No comments:
Post a Comment