|
-
OK like you guys suggested I used del_lf_rows_len and lf_rows_length and below is the result that I got.
Deleted Used % Deleted
Index Name Leaf Rows Leaf Rows Leaf Rows
------------------------------ --------- --------- ----------
PK_NEWSTABLE 0 1613 .00000
QUESTION: From the above results what is the best way to determine if the index needs to be rebuild?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote