Skip to main content

Index Rebuild and Index Reorganize

Index Rebuild
This process drops the existing Index and Recreates the index

Rebuild all indexes for the respective table
ALTER INDEX ALL ON < table name > REBUILD;

Rebuild specific indexes for the specific table
ALTER INDEX < Index Name > ON < Table Name > REBUILD;

Index Reorganize
This process physically reorganizes the leaf nodes of the index.

Reorganize all indexes for the specified table
ALTER INDEX ALL ON < table name > REORGANIZE;

Reorganize a specific index
ALTER INDEX < Index Name > ON < Table Name > REORGANIZE;

Recommendation: Index should be rebuild when index fragmentation is great than 40%. Index should be reorganized when index fragmentation is between 10% to 40%. Index rebuilding process uses more CPU and it locks the database resources. SQL Server development version and Enterprise version has option ONLINE, which can be turned on when Index is rebuilt. ONLINE option will keep index available during the rebuilding.
Labels:

Comments

Post a Comment

Popular posts from this blog

Know your Lha Zha, Sog Zha, Shi Zha

There is believe in Buddhism, that an individual person have got their own lucky day and bad luck day in a week. They are derived from the twelve animals similar to chiness horscope. Your birth year tells you which Buddhism zodiac sign you below to. Lha Zha and Sog Zha are belived to be good day while Shi zha is consider bad day.
Post a Comment
Read more

IPTABLES

Under linux OS, we use iptables to secure the machine from any other external attack. In current scenario I am forwarding the packages from local interface to external interface and i have squid configured which will be acting as transparent proxy. Only selective port numbers are open for the network. 1. Save the script to a file. 2. Give permission to execute. chmod +x filename . 3. Execute the file as follows ./filename 4. save the output of the script to system iptables file, by running the command service iptables save 5. You are done, start/restart the iptables service. service iptables restart Script: #!/bin/sh # chmod +x file name to execute # eth0 LAN # eth1 WAN # Local IP range 192.168.0.0/25 # NATing # Transparent proxy iptables -F iptables -X iptables -t nat -F iptables -t nat -X iptables -t mangle -F iptables -t mangle -X iptables -P INPUT ACCEPT iptables -P FORWARD ACCEPT iptables -P OUTPUT ACCEPT iptables -A INPUT -i lo -j ACCEPT iptables -A...
1 comment
Read more