-
Overflow Pages
Hello,
When running dbcc showcontig I get the following result: 'Pages Scanned ... 1000', 'Overflow Pages ... 999'.
I don't know what to think of this. The table doesn't have a clustered index, so how can their be any overflow pages? I thought you could only have overflow pages when you have a clustered index on the table. Second why is the number of overflow pages exactly 1 less than the total number of pages scanned?
I get this kind of result on 4 tables.
Anyway my 'real' problem is that inserts are slow. I guess this is probably due to page splits then. I would try to create a clustered index with the sorted_data_reorg option, but before doing that I'm hoping that someone can clarify the situation for me...
Stef
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
|
|