Hello all,

I have a table that I've just ran DBCC SHOWCONTIG ('Containers') against,
the scan density is coming out as 20% which I understand is bad, as it should
be above 75%, now ran DBREINDEX and also dropped and rebuilt all 4 indexes,
re ran the above and it's still coming out at 20%. Why is that and how do i
fix it?

Also, all columns (5) are of type 'int'.

Thanks,

Jon

How many pages are there? I there is less than 8 it will use mixed extents.
Also if none of the indexes are clustered you can reindex the table all you
want and wont get any where.

--
Andrew J. Kelly SQL MVP

"Jon" <Jon@discussions.microsoft.com> wrote in message
news:363C701D-8840-4C3B-B6FE-5BBA17153F19@microsoft.com...
> Hello all,
>
> I have a table that I've just ran DBCC SHOWCONTIG ('Containers') against,
> the scan density is coming out as 20% which I understand is bad, as it
> should
> be above 75%, now ran DBREINDEX and also dropped and rebuilt all 4
> indexes,
> re ran the above and it's still coming out at 20%. Why is that and how do
> i
> fix it?
>
> Also, all columns (5) are of type 'int'.
>
> Thanks,
>
> Jon
>

This was discussed in detail, with many responses, in .programming. Please
do not multi-post.

--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com


"Jon" <Jon@discussions.microsoft.com> wrote in message
news:363C701D-8840-4C3B-B6FE-5BBA17153F19@microsoft.com...
> Hello all,
>
> I have a table that I've just ran DBCC SHOWCONTIG ('Containers') against,
> the scan density is coming out as 20% which I understand is bad, as it
> should
> be above 75%, now ran DBREINDEX and also dropped and rebuilt all 4
> indexes,
> re ran the above and it's still coming out at 20%. Why is that and how do
> i
> fix it?
>
> Also, all columns (5) are of type 'int'.
>
> Thanks,
>
> Jon
>