Date / Time

 

Ads

News by month

News Categories

Link to us

Link to us

Ads

Subscribe

Search Promotion Data

Ads

News by month 2018

Latest News

Ads

Ads

SQL database corruption due to index fragmentation

on 03 Dec  Posted by Admin  Category: Programming  
by Jonny
http://www.stellarinfo.com

When it comes to the performance of raw databases, the biggest performance gaining mechanism could be the use of indexes. Database indexes improve access to your stored data, so you do not have to scan whole tables for accessing your data.

Indexing saves a lot of CPU, memory and I/O usage. Though, it is useful for databases to use indexes, over time the indexes could become fragmented. It makes the SQL server performance lower than usual, delayed transactions, locking, blocking and decreased throughput.

News Categories

Ads

All logos and trademarks in this site are property of their respective owner.

© 2001-18 PromotionData.com
A division of The Promotion Group network of sites.    Back to top ↑
e107 Theme by veskoto