your index may just grow with table, but not much delete. so you see index extent increase and no rebuild is nessary. you only need to rebuild index when deleted rows is more than 20% of total rows.
|
Results 1 to 3 of 3
Thread: rebuilding indexesThreaded View
|
Click Here to Expand Forum to Full Width |