Timeline for What does it mean when a table is listed with fragmentation?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 19, 2016 at 17:13 | comment | added | RLF | Are you using SQL Server 2014 Enterprise Edition? That gives you additional options for defragmentation. | |
| Sep 19, 2016 at 16:57 | comment | added | Ali Razeghi - AWS | Hmmm having indexes doesn't mean it's not a heap though. You can have indexes on a heap. Kin was specifically asking to see if you have a 'clustered' index on there. Can you let us know? Thanks. | |
| Sep 19, 2016 at 13:39 | comment | added | Racer SQL | Yes I checked it. they have some indexes. ( one of them has 6 indexes ). Some of them are being shown below the list with <5% fragmentation. I found A question here, where it said to "create a clustered index to reorganize the HEAP, and then drop it ". but i think it's not the case here. | |
| Sep 19, 2016 at 13:36 | comment | added | Kin Shah | Did you check if they are Heaps or not ? | |
| Sep 19, 2016 at 13:33 | comment | added | Racer SQL | Thanks kim. I will use it. but, what about the tables with AVG_fragmentation with null indexes? is this table fragmentation? I never heard it before and I would like to study it a little more. | |
| Sep 19, 2016 at 13:30 | history | answered | Kin Shah | CC BY-SA 3.0 |