Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DBCC SHOWCONTIG and indid


DBCC SHOWCONTIG and indid

Author
Message
MichaelJasson
MichaelJasson
SSC-Enthusiastic
SSC-Enthusiastic (112 reputation)SSC-Enthusiastic (112 reputation)SSC-Enthusiastic (112 reputation)SSC-Enthusiastic (112 reputation)SSC-Enthusiastic (112 reputation)SSC-Enthusiastic (112 reputation)SSC-Enthusiastic (112 reputation)SSC-Enthusiastic (112 reputation)

Group: General Forum Members
Points: 112 Visits: 191
I want to verify whether my understanding on SHOWCONTIG is correct or not.
DBCC SHOWCONTIG(269244014,1) and DBCC SHOWCONTIG(269244014) are same as both tell about the fragmentation of clustered index. There is nothing called fragmentation of table.

One more question: There are only four indexes but SELECT * FROM SYSINDEXES WHERE ID = 269244014 shows 7 indexes. From where these new 3 indexes has come.

-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
MichaelJasson
MichaelJasson
SSC-Enthusiastic
SSC-Enthusiastic (112 reputation)SSC-Enthusiastic (112 reputation)SSC-Enthusiastic (112 reputation)SSC-Enthusiastic (112 reputation)SSC-Enthusiastic (112 reputation)SSC-Enthusiastic (112 reputation)SSC-Enthusiastic (112 reputation)SSC-Enthusiastic (112 reputation)

Group: General Forum Members
Points: 112 Visits: 191
Any headsup!!

-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
MANU-J.
MANU-J.
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1958 Visits: 8766
Those might be statistics. Please post their names.

MJ
Glenn Dorling
Glenn Dorling
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2939 Visits: 918
If the other 3 "indices" are named "_WA_Sys..." then they're auto-generated statistics that SQL Server has created on non-indexed columns.

When the AutoCreateStatistics is turned on for a database the presence of a filter on a non-indexed field (eg. "... where LastName = 'Smith' ...", where LastName is not the first field in any of the indices on that table) will result in SQL Server creating statistics on that field, looking at the selectivity of the data in that field. The definition of this is stored in sys.indexes.

Don't worry about these: they're generally good things as they help SQL Server determine better (ie. more efficient) query plans.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search